Type may be a reserved keyword and need double quoting:
where "type"='client';
On Wed, Nov 18, 2009 at 6:23 AM, Dave Coventry 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: SEL
Hi,
try
SELECT title FROM node WHERE type='client';
hth
Thomas
Dave Coventry schrieb:
> 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;
>
>
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 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
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
SELECT title FROM node WHERE type='client'; Would this work?
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dave Coventry
Sent: Wednesday, November 18, 2009 6:24 AM
To: pgsql-general General
Subject: [GENERAL] column doe
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"
