From: Jaime Casanova <systemguards@yahoo.com>
To: Michael Glaesemann <grzm@myrealbox.com>
To: sad <sad@bankir.ru>
Cc: pgsql-sql@postgresql.org
Subject: Re: feature request ?
Date: Thu, 24 Jun 2004 12:32:59 -0500 (CDT)
Message-ID: <20040624173259.65980.qmail@web50006.mail.yahoo.com> (raw)
In-Reply-To: <6C87495E-C5F6-11D8-B2C1-000A95C88220@myrealbox.com>
Hi all,
Tri-valued boolean?? that's not against boolean concept?? i'm not saying that SQL is wrong nor Postgresql has to go beyond standard, i'm just trying to understand this stuff.
Why not disallow the ability of boolean fields to be null?
thanx in advance,
Jaime Casanova
Michael Glaesemann <grzm@myrealbox.com> wrote:
On Jun 24, 2004, at 6:39 PM, sad wrote:
> ...IF ELSEIF ELSE
> it's all clear
> but what about unequality of BOOL type possible value set and IF
> alternatives
> set
In my opinion the short answer is NULL is here because of the SQL
standard. The SQL standard does not specify any kind of "IF
alternative" for 3-valued logic afaik. Why should PostgreSQL go beyond
what the standard specifies in this hairy area? Three-valued logic is
something I strive to stay away from to the best of my ability, as it
is far too complicated for my feeble mind.
Michael Glaesemann
grzm myrealbox com
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
---------------------------------
Do You Yahoo!?
Todo lo que quieres saber de Estados Unidos, América Latina y el resto del Mundo.
Visíta Yahoo! Noticias.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: systemguards@yahoo.com, grzm@myrealbox.com, sad@bankir.ru
Subject: Re: feature request ?
In-Reply-To: <20040624173259.65980.qmail@web50006.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox