Conversion Oracle SQL to PostgreSQL -


i have problem convert script oracle postgres:

with q (     select 'abcde' str     dual) select 'test' wl_id     ,substr(str, level, 1) supply_mode_id q connect level < length(q.str) + 1; 

i tried in postgres:

with recursive t(n)      (select 'test', substring('abcde', 1, 1)         union         select 'test', substring('abcde', n+1,1)         t          n<length('abcde') ) select * t 

i have error :

error: operator not exist: text + integer

i don't know how return same result in oracle.


Comments