Re: column does not exist error

Поиск
Список
Период
Сортировка
Искать
От
Raymond O'Donnell
Тема
Re: column does not exist error
Дата
Msg-id
4B03F720.7060407@iol.ie
Ответ на
Список
Дерево обсуждения
column does not exist error Dave Coventry <dgcoventry@gmail.com>
Re: column does not exist error "Naoko Reeves" <naoko@lawlogix.com>
Re: column does not exist error Raymond O'Donnell <rod@iol.ie>
Re: column does not exist error Thomas Markus <t.markus@proventis.net>
Re: column does not exist error Vidhya Bondre <vbondre@zedo.com>
Re: column does not exist error Scott Marlowe <scott.marlowe@gmail.com>
Re: column does not exist error Thomas Kellerer <spam_eater@gmx.net>
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
В списке pgsql-general по дате отправления
От: Dave Coventry
Дата:
Сообщение: column does not exist error
От: Naoko Reeves
Дата:
FAQ