Skip site navigation (1) Skip section navigation (2)

Re: Boolean variables...

From: "Herbie McDuck" <herbie(at)faams(dot)net>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Boolean variables...
Date: 2003-08-30 00:44:39
Message-ID: 008001c36e8f$e51122b0$0a0ca8c0@FAAMSPROJECT (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)sss(dot)pgh(dot)pa(dot)us>
To: "Cath Lawrence" <Cath(dot)Lawrence(at)anu(dot)edu(dot)au>
Cc: <pgsql-novice(at)postgresql(dot)org>
Sent: Thursday, August 28, 2003 11:32 PM
Subject: Re: [NOVICE] Boolean variables...


> Cath Lawrence <Cath(dot)Lawrence(at)anu(dot)edu(dot)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


In response to

Responses

pgsql-novice by date

Next:From: Bruce MomjianDate: 2003-08-30 01:08:55
Subject: Re: Database names and pg_dump
Previous:From: chakkara rangarajanDate: 2003-08-29 20:44:49
Subject: synonym and design tool

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group