SELECT title FROM node WHERE type='client'; Would this work?
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Dave Coventry
Sent: Wednesday, November 18, 2009 6:24 AM
To: pgsql-general General
Subject: [GENERAL] column does not exist error
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