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@iol.ie