Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] Help me plz - Mailing list pgsql-bugs

From Kotadiya Dhrupesh
Subject Re: [BUGS] Help me plz
Date
Msg-id CAOKJcHCO2gAb2iuG_Sfb5rst-isna5MzezDfi0-9sc26hxYvRA@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] Help me plz  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: [BUGS] Help me plz  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: [BUGS] Help me plz  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-bugs
Tree view
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 by date:

Previous
From: Dmitry Dolgov
Date:
Subject: Re: [BUGS] BUG #14897: Segfault on statitics SQL request
Next
From: Marko Tiikkaja
Date:
Subject: Re: [BUGS] BUG #14870: wrong query results when using WITH with UPDATE