Thread: array element replace ?

2010/1/22 Gauthier, Dave <dave.gauthier@intel.com>:
> 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’.
>
Not sure you can replace an array value with an array (which kind of is
what you're asking in your example),  but:

http://www.postgresql.org/docs/8.4/static/arrays.html
Specifically section
 8.14.4. Modifying Arrays

Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm