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)
Список
Дерево обсуждения
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 по дате отправления