Re: newsfeed type query
От
Jonathan Vanasco
Тема
Re: newsfeed type query
Дата
Msg-id
31D4D498-4B17-4239-835D-F604C193ABA2@2xlp.com
Ответ на
Re: newsfeed type query (Jim Nasby)
Список
Дерево обсуждения
newsfeed type query Jonathan Vanasco <postgres@2xlp.com>
Re: newsfeed type query Ladislav Lenart <lenartlad@volny.cz>
Re: newsfeed type query Melvin Davidson <melvin6925@gmail.com>
Re: newsfeed type query Jonathan Vanasco <postgres@2xlp.com>
Re: newsfeed type query Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: newsfeed type query Ladislav Lenart <lenartlad@volny.cz>
Re: newsfeed type query Jonathan Vanasco <postgres@2xlp.com>
Re: newsfeed type query Ladislav Lenart <lenartlad@volny.cz>
Re: newsfeed type query Jonathan Vanasco <postgres@2xlp.com>
Re: newsfeed type query Ladislav Lenart <lenartlad@volny.cz>
Re: newsfeed type query Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: newsfeed type query Jonathan Vanasco <postgres@2xlp.com>
Re: newsfeed type query Ladislav Lenart <lenartlad@volny.cz>
Re: newsfeed type query Melvin Davidson <melvin6925@gmail.com>
On Apr 29, 2015, at 6:50 PM, Jim Nasby wrote:
Only because you're using UNION. Use UNION ALL instead.
On Apr 29, 2015, at 1:18 PM, Ladislav Lenart wrote:
I would expect the overall query to return only 60F nad 55F as the most recent
data. No? You expect it to return 4 items when the LIMIT is only 2. Remember
that the overall query should be also ordered by ts and limited to 2.
You're right. total mistake on my part and confusion with that. I got this query confused with the specifics of a similar one.
В списке pgsql-general по дате отправления
