Re: Setting week starting day

Поиск
Список
Период
Сортировка
Искать
От
Jorge Godoy
Тема
Re: Setting week starting day
Дата
Msg-id
87fy8eatj5.fsf@gmail.com
Ответ на
Список
Дерево обсуждения
Tabulate data incrementally Omar Eljumaily <omar2@omnicode.com>
Re: Tabulate data incrementally Richard Huxton <dev@archonet.com>
Setting week starting day (was: Re: Tabulate data incrementally) Jorge Godoy <jgodoy@gmail.com>
Re: Setting week starting day (was: Re: Tabulate data incrementally) Alvaro Herrera <alvherre@commandprompt.com>
Re: Setting week starting day Jorge Godoy <jgodoy@gmail.com>
Re: Setting week starting day Bruno Wolff III <bruno@wolff.to>
Re: Setting week starting day Jorge Godoy <jgodoy@gmail.com>
Re: Setting week starting day Alvaro Herrera <alvherre@commandprompt.com>
Re: Setting week starting day Jorge Godoy <jgodoy@gmail.com>
Re: Setting week starting day Bruno Wolff III <bruno@wolff.to>
Re: Setting week starting day Jorge Godoy <jgodoy@gmail.com>
Re: Setting week starting day Bruno Wolff III <bruno@wolff.to>
Re: Setting week starting day Jorge Godoy <jgodoy@gmail.com>
Re: Setting week starting day Bruno Wolff III <bruno@wolff.to>
Re: Setting week starting day Jorge Godoy <jgodoy@gmail.com>
Re: Setting week starting day Bruno Wolff III <bruno@wolff.to>
Re: Setting week starting day Omar Eljumaily <omar2@omnicode.com>
Re: Setting week starting day Jorge Godoy <jgodoy@gmail.com>
Re: Setting week starting day Jorge Godoy <jgodoy@gmail.com>
Re: Setting week starting day Bruno Wolff III <bruno@wolff.to>
Re: Setting week starting day Omar Eljumaily <omar2@omnicode.com>
Re: Tabulate data incrementally Tom Lane <tgl@sss.pgh.pa.us>
Re: Tabulate data incrementally Omar Eljumaily <omar2@omnicode.com>
Re: Tabulate data incrementally Alvaro Herrera <alvherre@commandprompt.com>
Re: Tabulate data incrementally Omar Eljumaily <omar2@omnicode.com>
Omar Eljumaily  writes:

> Ted, my reason for asking the question that I believe precipitated this thread
> was that I wanted a single sql statement that aggregated time data by week.
> Yes, I could do the aggregation subsequently in my own client side code, but
> it's easier and less error prone to have it done by the server.

If you work closer to the data you have more efficiency.  To do what you want
you can write a function using plpgsql -- I've posted some ideas -- and that
is not hard at all.

But if there was something to make it easier to write this it would be great ;-)

-- 
Jorge Godoy      
В списке pgsql-general по дате отправления
От: Jorge Godoy
Дата:
Сообщение: Re: Setting week starting day
От: Jorge Godoy
Дата:
Сообщение: Re: Setting week starting day
FAQ