Postgres Pro
Downloads
Home   >   mailing lists

Thread: [BUGS] Help me plz

[BUGS] Help me plz

From
Kotadiya Dhrupesh
Date:
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)


Please help me

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


 

Cell: +91-97270 50349

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

Re: [BUGS] Help me plz

From
Pavel Stehule
Date:
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
   
----------------------------------------------------------------------------------------------------------------------------

Re: [BUGS] Help me plz

From
Kotadiya Dhrupesh
Date:
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
   
----------------------------------------------------------------------------------------------------------------------------


Re: [BUGS] Help me plz

From
"David G. Johnston"
Date:
On Saturday, November 11, 2017, Kotadiya Dhrupesh <kotadiyadhrupesh@gmail.com> wrote:
 create_date::date <='20116-06-30' 

I doubt you meant to write a date approx. 20,000 years in the future there...

David J. 

Re: [BUGS] Help me plz

From
Tomas Vondra
Date:

On 11/11/2017 11:56 AM, Kotadiya Dhrupesh wrote:
> 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.
> 

So what exactly is wrong? Pavel already asked you to explain what you
think is wrong with the result, but you are just sending us "look at the
query" assuming it's somewhat obvious.

David already pointed out one possible issue (fat-fingered query
condition), but considering it wasn't there in the first request, I
doubt it's the actual issue.

regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs