On the BOOLEAN issue, it seems that a majority of the 'MAJOR', high dollar
DBs. do not support the boolean datatype.
Is PG supporting a depreciated feature or have the other DBs yet to catch
up?
--Herbie
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Cath Lawrence" <Cath.Lawrence@anu.edu.au>
Cc: <pgsql-novice@postgresql.org>
Sent: Thursday, August 28, 2003 11:32 PM
Subject: Re: [NOVICE] Boolean variables...
> Cath Lawrence <Cath.Lawrence@anu.edu.au> writes:
> > If I try to set a boolean to 'f' it works; if I set it to 't' it
> > actually sets it to false...
>
> Not here:
>
> regression=# create table t1 (f1 boolean);
> CREATE TABLE
> regression=# insert into t1 values('f');
> INSERT 1201117 1
> regression=# insert into t1 values('t');
> INSERT 1201118 1
> regression=# select * from t1;
> f1
> ----
> f
> t
> (2 rows)
>
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster