Re: [SQL] plpgsql setof help

2009-01-28 Thread Frank Bax
Tom Lane wrote: "Matthew T. O'Connor" writes: I want the following: select column_to_english_list( select towns from towns_table ); to return: 'town1, town2 and town3' I wonder though if it wouldn't be better to recast the problem as an aggregate: select column_to_english_list(towns) from

Re: [SQL] plpgsql setof help

2009-01-28 Thread Tom Lane
"Matthew T. O'Connor" writes: > I want the following: > select column_to_english_list( select towns from towns_table ); > to return: > 'town1, town2 and town3' > In order to do this, I think I would have to create a pl/pgsql function > that accpts a setof text argument, but I'm not sure that's