decode in oracle convert to postgres

Question

I want to convert the decode function from oracle to postgres command. example oracle command: select decode(p.statusgeometry,1,'pass','fail') as status

please help & guidance

select (case p.statusgeometry when 1 then 'pass' else 'fail' end) as status — Dornaut
– Dornaut, Commented Jul 23, 2021 at 9:02

Jim Jones · Accepted Answer · 2021-07-23 09:26:53Z

2

The decode equivalent is CASE:

WITH p (statusgeometry) AS (VALUES (1),(2))

SELECT 
  CASE statusgeometry
    WHEN 1 THEN 'pass'
    WHEN 2 THEN 'fail'
  END,
  -- The following syntax is useful in case you need to do  "something"  
  -- with the columns depending on the condition, e.g lower(), upper(), etc..
  CASE 
    WHEN statusgeometry = 1 THEN 'pass'
    WHEN statusgeometry = 2 THEN 'fail'
  END
FROM p;

 case | case 
------+------
 pass | pass
 fail | fail
(2 rows)

answered Jul 23, 2021 at 9:26

Jim Jones

19.9k3 gold badges44 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

decode in oracle convert to postgres

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related