case not sensitive to null condition ? - Mailing list pgsql-general

From Gauthier, Dave
Subject case not sensitive to null condition ?
Date
Msg-id 0AD01C53605506449BA127FB8B99E5E1624A1845@FMSMSX114.amr.corp.intel.com
Whole thread Raw
Responses Re: case not sensitive to null condition ?
List pgsql-general

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 !

 

pgsql-general by date:

Previous
From: Igor Neyman
Date:
Subject: Re: Windows query weird result
Next
From: Lutz Fischer
Date:
Subject: Re: Windows query weird result