Ron Mayer <[EMAIL PROTECTED]> 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

Reply via email to