Re: max timestamp
От
Bruno Wolff III
Тема
Re: max timestamp
Дата
Msg-id
20040215195152.GA570@wolff.to
Ответ на
max timestamp (stermic@gw.co.jackson.mo.us (Michael Sterling))
Список
Дерево обсуждения
max timestamp stermic@gw.co.jackson.mo.us (Michael Sterling)
Re: max timestamp Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: max timestamp Robert Creager <Robert_Creager@LogicalChaos.org>
Re: max timestamp Bruno Wolff III <bruno@wolff.to>
Re: max timestamp Tomasz Myrta <jasiek@klaster.net>
On Tue, Feb 10, 2004 at 10:14:04 -0800, Michael Sterling wrote: > i'm trying to get the max time stamp, from each day, of a range of > dates, not just the max time stamp for the complete range dates but > for each day. SELECT DISTINCT ON can probably do what you want. Something like: SELECT DISTINCT ON (timestamp::DATE) * FROM table ORDER BY timestamp DESC; This won't produce any records for days where there are no timestamps.
В списке pgsql-sql по дате отправления
