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
