Re: [GENERAL] why the need for is null?

[Mark Kirkwood]

Tom Lane wrote:

Not sure that it's fair to characterize this as a property of the
relational model.  It is a property of the SQL standard. 

Yes indeed - I fell into the classic "Relational model and SQL are not 
the same thing" trap !

Mark



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match