I am new to this forum. I need to return the value 1 between the orientationId tags in this xml string within the function below. I still get errors. I'm sure I am doing something wrong. Any help would be appreciated.
CREATE FUNCTION Davidxml9(v_clipId integer, v_orientationId varchar(1024), OUT clipId int, OUT orientationId varchar(1024)) AS $$ BEGIN clipId := v_clipId; orientationId := xpath('/Rows/Row/orientationId[1]/text()', content) FROM (SELECT v_orientationId ::xml AS orientationId); END; $$ LANGUAGE plpgsql; GO SELECT Davidxml9(1,'<Rows><Row><orientationId>1</orientationId></Row></Rows>')