Hi Kis, I don't think the GiST index has anything to do with this, i'm only processing one record. thx, WBL
On Thu, Feb 21, 2008 at 7:47 AM, Kis János Tamás <[EMAIL PROTECTED]> wrote: > csütörtök 14 február 2008 15.11 dátummal Willy-Bas Loos ezt írta: > > > > select 'yes' as foo > > from table1 a, table1 b > > where a.gid=4 > > and b.gid=4 > > and intersects(a.the_geom, b.the_geom) > > > > Did you try the next procedure? > > create index i_a on table1 usng gist the_geom; > create index i_b on table2 usng gist the_geom; > > select 'yes' as foo > from table1 a, table1 b > where a.gid=4 > and b.gid=4 > and a.the_geom && b.the_geom > and intersects(a.the_geom, b.the_geom) > > Regards, > kjt > > > McAfee SCM 4.1 által ellenőrizve! > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
