David Jarvis <thangalin@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
