Ron Mayer <rm_pg@xxxxxxxxxxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
