"Bjoern A. Zeeb" <[EMAIL PROTECTED]> writes:
> Is this correct or is it just a "works like that this time but may
> change at any time in the future"?
The meaning of a NULL for a composite value isn't real well-defined
at the moment. I tend to agree that "fbt IS NULL" should yield true
in your example, but I think there are/were some implementation reasons
why it doesn't.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
