Re: column does not exist error

SELECT title FROM node WHERE type='client'; Would this work?

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)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)