Type may be a reserved keyword and need double quoting: where "type"='client';
On Wed, Nov 18, 2009 at 6:23 AM, Dave Coventry <dgcoven...@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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
