How use enum in postgres

Question

I have created an enum type in Postgres:

CREATE TYPE myenum AS ENUM ('a', 'b', 'c', 'd');

I have created a function:

CREATE OR REPLACE FUNCTION public.mystore(type myenum)

Now in the stored procedure how I can check if a type is 'a' or 'b' like

if(type = myenum.a or type =  myenum.b) then
   ...
end if;

In fact the last line of code is not working.

Kouber Saparev · Accepted Answer · 2014-11-28 16:45:37Z

3

IF (type = 'a' OR type = 'b') THEN
  ...
END IF;

answered Nov 28, 2014 at 16:45

Kouber Saparev

8,2552 gold badges32 silver badges28 bronze badges

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

Comments

Erwin Brandstetter · Accepted Answer · 2014-11-28 16:45:47Z

2

Just use a string literal:

WHERE type = 'a' OR type = 'b'

Or:

WHERE type IN ('a', 'b')

answered Nov 28, 2014 at 16:45

669k160 gold badges1.2k silver badges1.3k bronze badges