Re: Help me plz

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