Re: NULL OR ZERO

From: Rodrigo E(dot) De León Plicet <rdeleonp(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: NULL OR ZERO
Date: 2008-02-06 21:38:32
Message-ID: a55915760802061338q78cefb98vccbbc1198d79445@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Feb 3, 2008 7:41 PM, Jaime Casanova <systemguards(at)gmail(dot)com> wrote:
> On Feb 3, 2008 7:26 PM, Omar Bettin <o(dot)bettin(at)tiscali(dot)it> wrote:
> > Probably I am on the wrong place but for me NULL on numbers means 0 or ZERO.
> > I know about standards...
> >
>
> NULL means unknown value, ZERO is a known value

NULL represents absence of a value. You get the UNKNOWN truth value if
you compare NULL with any data value or another NULL (damn you, 3VL!).

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2008-02-06 22:08:04 Re: build environment: a different makefile
Previous Message Stefan Kaltenbrunner 2008-02-06 21:30:07 Re: PostgreSQL 8.4 development plan