Top "Postgresql-8.4" questions

This is for PostgreSQL questions specific to version 8.4.

ERROR: function unnest(integer[]) does not exist in postgresql

SELECT UNNEST(ARRAY[1,2,3,4]) While executing the above query I got the error like this: ERROR: function unnest(integer[]) does not …

Read More
postgresql rails-postgresql postgresql-9.0 postgresql-8.4
Filter by date range (same month and day) across years

I have a PostgreSQL database with a table holding dates. Now I need to find all rows within the date …

Read More
sql database postgresql date postgresql-8.4
Analysing/Profiling queries on PostgreSQL

I've just inherited an old PostgreSQL installation and need to do some diagnostics to find out why this database is …

Read More
sql postgresql plpgsql postgresql-8.4