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