empty string v.s. null

[jgmagnus]

look at the following then tell me if it proves you wrong. If not I'll try something else:

dbdev:staging> select count(*) from test where string IS NULL;

COUNT(*)
----------
2

dbdev:staging> insert into test values (' ');

1 row created.

dbdev:staging> commit;

Commit complete.

dbdev:staging> select count(*) from test where string IS NULL;

COUNT(*)
----------
2


- magnus