RE: Format of BOOLEAN

From: Nicolas Huillard <nhuillard(at)ghs(dot)fr>
To: "'Lehmeier, Michael'" <michael(dot)lehmeier(at)cognitech(dot)de>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: RE: Format of BOOLEAN
Date: 2001-06-12 18:01:32
Message-ID: 01C0F37A.7B08AE20.nhuillard@ghs.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Message d'origine-----
> De: Lehmeier, Michael [SMTP:michael(dot)lehmeier(at)cognitech(dot)de]
> Date: jeudi 7 juin 2001 18:06
> Objet: [GENERAL] Format of BOOLEAN
>
> testdb=# SELECT * FROM testtable WHERE acolumn = t;
> ERROR: Attribute 't' not found

testdb=# SELECT * FROM testtable WHERE acolumn = 't';

Don't forget the single quote around the t : a boolean is a single char...

NH

Browse pgsql-general by date

  From Date Subject
Next Message Darren Chamish 2001-06-12 18:02:45 Utility for Exporting from Oracle 8i to Postgre??
Previous Message Thalis A. Kalfigopoulos 2001-06-12 17:59:10 Re: Format of BOOLEAN