Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> writes:
> I tried making an aggregate function that concatenates
> any non-null strings it encounters, as shown below.
> The function works fine on small tables; but when I run
> it on one of my larger tables it seems to me that it
> crashes the backend - though I don't see anything obvious
> in the log.
I tried this example in CVS tip and didn't see any particular misbehavior.
What PG version are you running? Does EXPLAIN show that the query is
being done with a group or hash aggregation? What do you have sort_mem
set to?
regards, tom lane