On Mon, Sep 05, 2005 at 03:00:30AM +0300, Sterpu Victor wrote: > Can I do something like this? > SELECT sum(name) FROM table; > > Where name is a text field. > I know 'sum' doesn't work, but is there another solution? > '||' is not good because it will take just 2 arguments. Currently, you can use a custom aggregate like array_accum() http://www.postgresql.org/docs/current/static/xaggr.html combined with the array_to_string() like this: SELECT array_to_string(array_accum(email), ', ') AS "emails" FROM person_email; Hope this helps :) Cheers, D -- David Fetter david@xxxxxxxxxx http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
