Re: column does not exist error

Can you try reframing it as :

SELECT title FROM node WHERE type='client;

Regards
Vidhya

On Wed, Nov 18, 2009 at 6:53 PM, Dave Coventry <dgcoventry(at)gmail(dot)com> wrote:

> Tearing my hair out, can anyone see what I'm doing wrong?
>
> SELECT title FROM node WHERE type=client;
>
> ERROR: column "client" does not exist
> LINE 1: SELECT title FROM node WHERE type=client;
>
> Yet this works:
>
> SELECT type FROM node;
> type
> --------
> client
> client
> client
> client
> client
> (5 rows)
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>