Re: column does not exist error

Type may be a reserved keyword and need double quoting:

where "type"='client';

On Wed, Nov 18, 2009 at 6:23 AM, 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
>

--
When fascism comes to America, it will be intolerance sold as diversity.