Re: Part 2 of "Intentional, or a bug".... - Mailing list pgsql-sql

From Kovacs Baldvin
Subject Re: Part 2 of "Intentional, or a bug"....
Date
Msg-id Pine.GSO.4.33.0109171043590.20920-100000@ural2
Whole thread Raw
In response to Re: Part 2 of "Intentional, or a bug"....  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
> > After these I use ~= if I need lines with NULLs in both to be selected.
>
> Perhaps you should reconsider your data model.  You seem to be treating

The given column is a date type column, with some records where
"date is not given". This "not given" is represented by NULL.
I saw it more elegant than assigning a date in the very past for
"not given", or using a boolean column called "date given".

After all, I consider using the additional boolean column.

Bye,
Baldvin






pgsql-sql by date:

Previous
From: Richard NAGY
Date:
Subject: Re: SQL request change when upgrade from 7.0.2 to 7.1.3
Next
From: Haller Christoph
Date:
Subject: Re: Number the lines