| From: | Tim Landscheidt <tim(at)tim-landscheidt(dot)de> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Analysis Function |
| Date: | 2010-06-11 18:53:44 |
| Message-ID: | m3eigdh03r.fsf@passepartout.tim-landscheidt.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
David Jarvis <thangalin(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-06-11 20:20:55 | Re: Analysis Function |
| Previous Message | Bob Lunney | 2010-06-11 18:50:10 | Re: Query about index usage |