Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8GN7l792436 for ; Sun, 16 Sep 2001 19:07:47 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f8GN62K19231; Sun, 16 Sep 2001 19:06:02 -0400 (EDT) To: Kovacs Baldvin cc: pgsql-sql@postgresql.org Subject: Re: Part 2 of "Intentional, or a bug".... In-reply-to: References: Comments: In-reply-to Kovacs Baldvin message dated "Mon, 17 Sep 2001 00:02:29 +0200" Date: Sun, 16 Sep 2001 19:06:01 -0400 Message-ID: <19228.1000681561@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200109/97 X-Sequence-Number: 4761 Kovacs Baldvin writes: > 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 NULL as if it were a real value, which is something that SQL discourages rather strongly... regards, tom lane