Received: from ural2.hszk.bme.hu (ural2.hszk.bme.hu [152.66.130.2]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8H8lt796344 for ; Mon, 17 Sep 2001 04:47:55 -0400 (EDT) (envelope-from kb136@hszk.bme.hu) Received: (from kb136@localhost) by ural2.hszk.bme.hu (8.11.3/8.11.3) id f8H8lpN23123; Mon, 17 Sep 2001 10:47:51 +0200 (MEST) Date: Mon, 17 Sep 2001 10:47:51 +0200 (MEST) From: Kovacs Baldvin X-X-Sender: To: Tom Lane cc: Subject: Re: Part 2 of "Intentional, or a bug".... In-Reply-To: <19228.1000681561@sss.pgh.pa.us> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200109/101 X-Sequence-Number: 4765 > > 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