Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Part 2 of "Intentional, or a bug"....
Date
Msg-id 19228.1000681561@sss.pgh.pa.us
Whole thread Raw
In response to Part 2 of "Intentional, or a bug"....  (Kovacs Baldvin <kb136@hszk.bme.hu>)
Responses Re: Part 2 of "Intentional, or a bug"....
List pgsql-sql
Tree view 
Kovacs Baldvin <kb136@hszk.bme.hu> 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

pgsql-sql by date:

Previous
From: Kovacs Baldvin
Date:
Subject: Part 2 of "Intentional, or a bug"....
Next
From: Richard NAGY
Date:
Subject: Re: SQL request change when upgrade from 7.0.2 to 7.1.3