v9.0.1 on linux thedb=# select ''''||bicolumn||'''', coalesce(permitted_values,'is_null'), case permitted_values when NULL then 'null' else ''''||permitted_values||'''' end from bi_constraints limit 2;
?column? | coalesce | case
----------------+---------------+-----------------
'block' | is_null | <--- should be 'null' ??
'design_style' | rls,analog,fc | 'rls,analog,fc'
(2 rows)
Why didn't the case return 'null' in the statement above?
Thanks in Advance !
