Thread: xml question
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>')
David Ekren wrote
> 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>
> ')
1. Try solving your xpath problem without using a custom function.
2. Go and read the documentation on writing plpgsql functions a couple of
times. What you have written here has at least six major problems.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/xml-question-tp5801793p5801819.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.