regexp_substr equivalent in postgresql

Question

I have this code in oracle PLSQL:

select * from con_transaccioncabecera c
where c.cab_estadocon in
(select regexp_substr('S-C-I-A','[^-]+',1,level) from dual
connect by regexp_substr('S-C-I-A','[^-]+',1,level) is not NULL)

I typed the string 'S-C-I-A', but actually, there would go a variable.

I need an equivalent in plpgsql.

score 2 · Accepted Answer · 2021-12-14 07:18:17Z

2

This is much easier in Postgres (no PL/pgSQL required)

select * 
from con_transaccioncabecera c
where c.cab_estadocon = any (string_to_array('S-C-I-A','-'))

edited Dec 14, 2021 at 7:18

answered Dec 13, 2021 at 21:44

user330315

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

Collectives™ on Stack Overflow

regexp_substr equivalent in postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related