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

Dave Coventry, 18.11.2009 14:23:
> 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;
>

You are missing the quotes to identify a character literal:

SELECT title FROM node WHERE type='client';

Thomas