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 NULL, email_address character varying(250), is_mil numeric, is_civ numeric, is_ctr numeric, is_gov numeric, is_edu numeric, role_id character varying(50), user_profile_id character varying(50), service_branch_id character varying(50), mil_pay_grade_id character varying(50), my_auds character varying(4000), my_orgs character varying(4000), processed character(1) DEFAULT 'N'::bpchar NOT NULL );
insert into user_pool_clean values('995CECDC1881375DE05312A270C7CF56','10015706','noemail@fter.dbrefresh.mil',0,0,0,0,0,'1','4','700006','3','1706882','1707720','Y');
insert into user_pool_clean values('995CECDC1905375DE05312A270C7CF56','10015848','noemail@fter.dbrefresh.mil',0,0,0,0,0,'1','3','700015','11',' 1705562,1708486','1710621','Y');