Re: Help needed with XMLTABLE

2020-04-15 Thread Dilip Kumar
On Wed, Apr 15, 2020 at 12:56 PM Pavel Stehule wrote: > st 15. 4. 2020 v 7:32 odesílatel Dilip Kumar napsal: >> >> One of our customers tried to use XMLTABLE syntax without >> row_expression, which works fine with ORACLE but doesn't work with >> PostgreSQL. So can anyone suggest what alternative

Re: Help needed with XMLTABLE

2020-04-15 Thread Pavel Stehule
st 15. 4. 2020 v 7:32 odesílatel Dilip Kumar napsal: > One of our customers tried to use XMLTABLE syntax without > row_expression, which works fine with ORACLE but doesn't work with > PostgreSQL. So can anyone suggest what alternative we can use? > > CREATE TABLE user_pool_clean ( > fk_user_

Re: Help needed with XMLTABLE

2020-04-15 Thread Pavel Stehule
st 15. 4. 2020 v 7:32 odesílatel Dilip Kumar napsal: > One of our customers tried to use XMLTABLE syntax without > row_expression, which works fine with ORACLE but doesn't work with > PostgreSQL. So can anyone suggest what alternative we can use? > > CREATE TABLE user_pool_clean ( > fk_user_

Help needed with XMLTABLE

2020-04-14 Thread Dilip Kumar
One of our customers tried to use XMLTABLE syntax without row_expression, which works fine with ORACLE but doesn't work with PostgreSQL. So can anyone suggest what alternative we can use? CREATE TABLE user_pool_clean ( fk_user_pool_pk bytea NOT NULL, user_id character varying(255) NOT NUL