Re: column does not exist error

From: Thomas Markus <t(dot)markus(at)proventis(dot)net>
To: Dave Coventry <dgcoventry(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: column does not exist error
Date: 2009-11-18 13:35:29
Message-ID: 4B03F821.9040602@proventis.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;
>
> Yet this works:
>
> SELECT type FROM node;
> type
> --------
> client
> client
> client
> client
> client
> (5 rows)
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2009-11-18 13:39:05 Re: passing parameters to multiple statements
Previous Message Thomas Kellerer 2009-11-18 13:33:37 Re: column does not exist error