til icon indicating copy to clipboard operation
til copied to clipboard

CTE with multi rows + set default value

Open xluffy opened this issue 1 year ago • 0 comments

WITH keke AS (
  SELECT '{"a":1,"b":2}'::jsonb AS attribute UNION ALL
  SELECT '{"a":1,"c":2}'::jsonb AS attribute UNION ALL
  SELECT '{"b":1,"c":2}'::jsonb AS attribute
)

--SELECT attribute FROM keke;
SELECT CASE 
	WHEN attribute->>'c' IS NOT NULL THEN attribute->>'c'
	WHEN attribute->>'c' IS NULL THEN 'default'
	END AS c FROM keke;

xluffy avatar Sep 19 '23 06:09 xluffy