Format of BOOLEAN

From: "Lehmeier, Michael" <michael(dot)lehmeier(at)cognitech(dot)de>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Format of BOOLEAN
Date: 2001-06-07 16:05:47
Message-ID: 2BC8FB121C58D4118D5100D0B72016BA8394@tznks01.ct.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

When I SELECT a row with a BOOLEAN in it I get either 't' or 'f'.
But when I use this same value in the WHERE condition I get an error,
because PostgreSQL demands either 'true' or 'false'.

Example:

testdb=# create table testtable (acolumn BOOLEAN);
CREATE
testdb=# INSERT INTO testtable VALUES (true);
INSERT 161246 1
testdb=# SELECT * FROM testtable;
acolumn
---------
t
(1 row)

testdb=# SELECT * FROM testtable WHERE acolumn = t;
ERROR: Attribute 't' not found

This is a real problem for me since I am currently writing on a mostly
database independent engine. PostgreSQL would be the the first time that
I can't write into a database what I read from it.

Is it possible to change the settings of PostgreSQL somewhere so that
I get 'true' or 'false'?

Thank you!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message zilch 2001-06-07 16:38:44 WAS: PostgreSQL Replication Server? IS: Zend comparison chart
Previous Message zilch 2001-06-07 15:51:55 inserting, index and no index - speed