Re: Fixing set-returning functions are not allowed in UPDATE after upgrade to Postgres 12

["Andrus" <kobruleht2@xxxxxx>]

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

But got error

   ERROR:  syntax error at or near "["
   LINE 3: .../BuyerParty/ContactData/ContactFirstName/text()',x)[1]::text

How to fix ?

Posted also in 

https://stackoverflow.com/questions/60993975/fixing-set-returning-functions-are-not-allowed-in-update

Andrus.