I suppose that PostgreSQL insists that a NULL value cannot be
concatenated with a string. Can I cast this somehow? I noticed that
feature when I did a
select * from tab where col1||col2 ilike '%bla%'
and it did't find rows where one of the columns was NULL. Any ideas for
workarounds?
--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1