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
AL] 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
---
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"
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)
