"Gustav Lindenberg" <gustav.lindenberg@xxxxxxxxx> writes:
> Why is '' not considered null is postgres (8.1.3)
Because they're different. The SQL spec says that an empty string
is different from NULL, and so does every database in the world except
Oracle. Oracle, however, does not define the standard.
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
