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@gmail.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@postgresql.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.