Re: [GENERAL] [postgis-users] Union as an aggregate

2003-09-30 Thread strk
tgl wrote: > strk <[EMAIL PROTECTED]> writes: > > If I run that again, *exactly the same query*: > > PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND > > 566 pgsql 14 0 126M 126M 3396 S 0.0 16.8 7:13 postmaster > > > It looks like someone is leaking memory, eit

Re: [GENERAL] [postgis-users] Union as an aggregate

2003-09-30 Thread Tom Lane
strk <[EMAIL PROTECTED]> writes: > dblasby wrote: >> Hum - this shouldnt do anything. >> The aggregate should have "null" as its initial value. >> GeomUnion(null,) --> null. >> So, you'll end up with null *very* quickly because >> GeomUnion(null,) returns null without any actual execution. > It l

Re: [GENERAL] [postgis-users] Union as an aggregate

2003-09-30 Thread strk
dblasby wrote: > strk wrote: > > Dave, I made no special 'unite' code, just sql create command: > > CREATE AGGREGATE unite ( > > sfunc = GeomUnion, > > basetype = geometry, > > stype = geometry > > ); > > Hum - this shouldnt do anything. > > The aggregate should have "null" as its ini