Re: Analysis Function

Поиск
Список
Период
Сортировка
От Tim Landscheidt
Тема Re: Analysis Function
Дата
Msg-id m3eigdh03r.fsf@passepartout.tim-landscheidt.de
обсуждение исходный текст
Ответ на Re: Analysis Function  (David Jarvis <thangalin@gmail.com>)
Список pgsql-performance
David Jarvis <thangalin@gmail.com> wrote:

> [...]
>> invest too much time to have the user wait not 4.4, but
>> 2.2 seconds. You could also do the concatenation in the ap-
>> plication if that is faster than PostgreSQL's date arithme-
>> tics.

> No, I cannot. The concatenation uses the year that the measurement was
> made--from the database--and the month/day combination from the user. See
> also:

> http://stackoverflow.com/questions/2947105/calculate-year-for-end-date-postgresql

That page doesn't deal with "select year from database and
month/day from user and present the results", but *much*
different problems.

Tim

В списке pgsql-performance по дате отправления:

Предыдущее
От: Bob Lunney
Дата:
Сообщение: Re: Query about index usage
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Analysis Function