Re: [SQL] assorted problems with intarray and other GiST contribs.

On Sun, Jun 26, 2005 at 06:48:42PM +0200, PFC wrote: > > SELECT int_array_aggregate(id) FROM (SELECT id FROM shop.products LIMIT X) > as foo; > > This one works fine if X <= 512 and crashes postgres if X > 512. > ie. if the aggregate accumulates more than 512 values it crashes. I d

Re: [SQL] assorted problems with intarray and other GiST contribs.

Thanks for the quick response ! * int_array_aggregate crashes I don't remember this function :) You mean it's not part of intarray contrib ? I thought so ! Sorry ! Then who's responsible for maintenance of it ? int4 nlevel(ltree) - r

Re: [SQL] assorted problems with intarray and other GiST contribs.

On Sun, 26 Jun 2005, PFC wrote: Hello ! I'm using postgresql 8.0.1-r2 on gentoo linux. So, here are the problems : * int_array_aggregate crashes I don't remember this function :) * ltree First of all co

[SQL] assorted problems with intarray and other GiST contribs.

Hello ! I'm using postgresql 8.0.1-r2 on gentoo linux. So, here are the problems : * int_array_aggregate crashes SELECT int_array_aggregate(id) FROM (SELECT id FROM shop.products LIMIT X) as foo; This one