Skip to main content

Cannot getting empty result in case

  • May 30, 2019
  • 2 replies
  • 7 views

mgvertica
Forum|alt.badge.img+1

I cannot get empty result in case and it returns NULL result:

SELECT CASE WHEN ('test' IS NULL) THEN (SELECT 'null_result') ELSE (SELECT 'empty_result' WHERE 1<>1) END;

2 replies

mgvertica
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • June 1, 2019

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • June 3, 2019

The query gives correct results:

dbadmin=> SELECT CASE WHEN ('test' IS NULL) THEN (SELECT 'null_result') ELSE (SELECT 'empty_result' WHERE 1<>1) END;
 case
------

(1 row)

dbadmin=> SELECT CASE WHEN ('test' IS NULL) THEN (SELECT 'null_result') ELSE (SELECT 'empty_result' WHERE 1=1) END;
     case
--------------
 empty_result
(1 row)