2010/1/22 Gauthier, Dave <dave.gauthier@xxxxxxxxx>: > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
