column does not exist error

Can you try reframing it as :

SELECT title FROM node WHERE type='client;

Regards
Vidhya

On Wed, Nov 18, 2009 at 6:53 PM, Dave Coventry <dgcoventry@gmail.com> wrote:

On 18/11/2009 13:23, Dave Coventry wrote:

Tearing my hair out, can anyone see what I'm doing wrong?

SELECT title FROM node WHERE type=client;

You need to quote literal values:

SELECT title FROM node WHERE type='client';

Otherwise PG thinks you're referring to a column called "client", as you
saw.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

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

Dave Coventry, 18.11.2009 14:23:

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;

You are missing the quotes to identify a character literal:

SELECT title FROM node WHERE type='client';

Thomas

Hi,

try

SELECT title FROM node WHERE type='client';

hth
Thomas

Dave Coventry schrieb:

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.