On Thu, Apr 2, 2020 at 11:38 PM Andrus <kobrule...@hot.ee> wrote: > Hi! > > >Simply replace > > SET col = unnest(array_value) > >with > > > > SET col = array_value[1] > > I tried > >
> update temprid set > ContactFirstName =xpath( > > > '/E-Document/Document/DocumentParties/BuyerParty/ContactData/ContactFirstName/text()',x)[1]::text > > Parens around the function call expression are required per the syntax documentation for array subscript access: https://www.postgresql.org/docs/current/sql-expressions.html#SQL-EXPRESSIONS-SUBSCRIPTS update temprid set ContactFirstName =(xpath( '/E-Document/Document/DocumentParties/BuyerParty/ContactData/ContactFirstName/text()',x) )[1]::text David J.
