Thanks a lot,It worked for me.
Thanks & Regards,
Thanks & Regards,
Saritha
On Thu, Oct 3, 2013 at 6:40 PM, David Johnston <polobo@xxxxxxxxx> wrote:
saritha N wrote
> ERROR: invalid value "{0" for "dd"The leading "{" in the data is the big give away. This is how a string
> DETAIL: Value must be an integer.
representation of an array looks. From the documentation:
http://www.postgresql.org/docs/9.3/interactive/functions-xml.html
> The function xpath evaluates the XPath _expression_ xpath (a text value)
> against the XML value xml. It returns an array of XML values corresponding
> to the node set produced by the XPath _expression_. If the XPath _expression_
> returns a scalar value rather than a node set, a single-element array is
> returned.
If you want to convert the result of an xpath query you need to operate over
an array. Usually that means unnesting though there are other
possibilities. If you know you are only dealing (or care about) the first
element you can simply code it as (xpath(...))[1] - note the surrounding
parentheses - to get that first element.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Unable-to-convert-xpath-value-to-date-tp5773204p5773223.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
