Nilesh Govindarajan wrote:
Hi,In my query, some rows have null values (length 0).
a NULL value is not length 0, NULL is not the empty string, rather, NULL is no value at all.
if you want to change a 0 length string to something, use a CASE or something.
select CASE WHEN u.name = '' THEN 'anon' ELSE u.name, .... -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
