Re: [BUGS] Help me plz

Поиск
Список
Период
Сортировка
От Kotadiya Dhrupesh
Тема Re: [BUGS] Help me plz
Дата
Msg-id CAOKJcHCO2gAb2iuG_Sfb5rst-isna5MzezDfi0-9sc26hxYvRA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [BUGS] Help me plz  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: [BUGS] Help me plz  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: [BUGS] Help me plz  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-bugs
Hello,

Thanks for update.

v2=# select id,name,create_date from res_partner where supplier =False and customer=True and create_date::date <='20116-06-30' order by id desc limit 2
;
    id    |      name      |        create_date         
----------+----------------+----------------------------
 13845945 | Faryal Ahmed   | 2017-11-09 13:47:28.063494
 13845944 | Ahmad Alghamdi | 2017-11-09 13:47:22.831375
(2 rows)


Please look above query.

Thanks,


Regards,
---------------------------------------------------------------------------------------------------------------------------
Dhrupesh Kotadiya
Sr. Odoo Developer


 

Cell: +91-97270 50349

Skype: dhrupesh.kotadiya
Twitter : KDhrupesh
   
----------------------------------------------------------------------------------------------------------------------------

On Thu, Nov 9, 2017 at 7:11 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
Hi

2017-11-09 15:13 GMT+01:00 Kotadiya Dhrupesh <kotadiyadhrupesh@gmail.com>:
Hello,

I have got following output when run query in postgress.

v2=# select id,name,create_date from res_partner where supplier =False and customer=True  order by id desc limit 2
;
    id    |     name      |        create_date        
----------+---------------+----------------------------
 13845976 | Ruth Acuna    | 2017-11-09 13:48:38.755767
 13845975 | Jenny ramirez | 2017-11-09 13:48:38.755767
(2 rows)



It is not a bug. Please, use mailing list pgsql-general instead.

What is wrong there? Looks ok

Regards

Pavel


 
Please help me

Regards,
---------------------------------------------------------------------------------------------------------------------------
Dhrupesh Kotadiya
Sr. Odoo Developer


 

Cell: +91-97270 50349

Skype: dhrupesh.kotadiya
Twitter : KDhrupesh
   
----------------------------------------------------------------------------------------------------------------------------


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Dmitry Dolgov
Дата:
Сообщение: Re: [BUGS] BUG #14897: Segfault on statitics SQL request
Следующее
От: Marko Tiikkaja
Дата:
Сообщение: Re: [BUGS] BUG #14870: wrong query results when using WITH with UPDATE