Re: column does not exist error - Mailing list pgsql-general

Hi,

try

SELECT title FROM node WHERE type='client';


hth
Thomas


Dave Coventry schrieb:
> 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)
>
>