[SQL] Which version of PostgreSQL should I use.

Hi there, Let me first preface this with, I am not a PostgreSQL admin. I am a web developer who happens to use PSQL as the back-end for my company's app. We did have a dedicated DBA / system admin - but he has recently resigned. I know enough about psql - to be able to create / drop databases...

[SQL] unnest in SELECT

I have a couple of questions regarding unnest. 1) If I issue a select statement select unnest(vector1) as v from some_table, I cannot seem to use the column alias v in a WHERE or HAVING clause. I can use it in an ORDER BY or GROUP by clause. Is this the way it is supposed to work? 2) If I

Re: [SQL] Which version of PostgreSQL should I use.

We're currently using psql 8.1 and are on the way to upgrading to 8.4. The tools pg_dump pg_restore are used to extract and re-create databases. Can be used for chores such as deploying from development to production, backing up, and upgrading.

Re: [SQL] unnest in SELECT

On 05/21/2011 03:13 AM, Karl Koster wrote: I have a couple of questions regarding unnest. 1) If I issue a select statement select unnest(vector1) as v from some_table, I cannot seem to use the column alias v in a WHERE or HAVING clause. I can use it in an ORDER BY or GROUP by clause. Is this