Re: Unable to convert xpath value to date

Thanks a lot,It worked for me.

Thanks & Regards,
Saritha

On Thu, Oct 3, 2013 at 6:40 PM, David Johnston <polobo(at)yahoo(dot)com> wrote:

> saritha N wrote
> > ERROR: invalid value "{0" for "dd"
> > DETAIL: Value must be an integer.
>
> The leading "{" in the data is the big give away. This is how a string
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>