On 18/11/2009 13:23, Dave Coventry wrote: > Tearing my hair out, can anyone see what I'm doing wrong? > > SELECT title FROM node WHERE type=client; You need to quote literal values: SELECT title FROM node WHERE type='client'; Otherwise PG thinks you're referring to a column called "client", as you saw. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
