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 !

Reply via email to