array element replace ? - Mailing list pgsql-general

From Gauthier, Dave
Subject array element replace ?
Date
Msg-id 482E80323A35A54498B8B70FF2B87980043ADEF015@azsmsx504.amr.corp.intel.com
Whole thread Raw
Responses Re: array element replace ?  (Andrej <andrej.groups@gmail.com>)
List pgsql-general

Is there a clever way to replace a single element in an array with another value?

 

E.g.

 

x = array[‘a’,’b’,’c’,’d’];

 

I want to replace ‘b’ with ‘x’.

 

Thanks for any suggestions!

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Old/New
Next
From: Andrej
Date:
Subject: Re: array element replace ?