On Thursday, November 10, 2011 8:56:56 am you wrote: > "PostgreSQL 8.4.9 on i686-pc-linux-gnu, compiled by GCC gcc-4.4.real > (Ubuntu/Linaro 4.4.4-14ubuntu5) 4.4.5, 32-bit" > Please reply to the list also. That gets your issue in front of more eyes:) The above answers my first question. The second question is still out there: Where are you running the above from? You say it runs fine in PgAdmin, so where are running the query to get the error message? -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general