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>')