[postgis-users] function speed

2007-05-31 Thread Christo Du Preez
I wonder if someone can perhaps shed so light on a very strange issue. I'm not sure if this is a postgis or postgres question. I've written a function that takes a geometry and a couple of other arguments then in the function I simply select from a table with 6.5mil rows using WHERE

Re: [postgis-users] function speed

2007-05-31 Thread Mark Cave-Ayland
On Thu, 2007-05-31 at 17:47 +0200, Christo Du Preez wrote: I wonder if someone can perhaps shed so light on a very strange issue. I'm not sure if this is a postgis or postgres question. I've written a function that takes a geometry and a couple of other arguments then in the function I

RE: [postgis-users] function speed

2007-05-31 Thread Obe, Regina
From: [EMAIL PROTECTED] on behalf of Christo Du Preez Sent: Thu 5/31/2007 1:27 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] function speed Thanx for all the replies. The only thing I haven't tried is using the EXECUTE method in my plpgsql function. I did