Re: Re: very big problem with NULL

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Alexey Borzov <borz_off(at)rdw(dot)ru>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Grant <grant(at)xactcommerce(dot)com>, missive(at)hotmail(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Re: very big problem with NULL
Date: 2001-06-13 13:25:35
Message-ID: 20010613082535.C20924@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 13, 2001 at 04:33:40PM +0400,
>
> newweb=# select version();
> version
> ---------------------------------------------------------------------
> PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
> (1 row)
>
> newweb=# select null=null;
> ?column?
> ----------
> t
> (1 row)

This is even stranger:

area=> select null<>null;
?column?
----------

(1 row)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message J.H.M. Dassen Ray 2001-06-13 13:30:21 Re: Unix time stamp function?
Previous Message Bruno Wolff III 2001-06-13 13:21:15 Re: Exploring sequences (sequence context within a tran saction)