[postgis] without islossy

mj_vermeij mj_vermeij at yahoo.com
Mon Jan 14 02:49:19 PST 2002


Sorry, simple question here,

Is it allowed to create an indexing whilst ommitting the 
'with (ISLOSSY)' statement?

example

create index boundary_0b on boundary 
using GIST (shape GIST_GEOMETRY_OPS);

with shape created by:

SELECT AddGeometryColumn ('lki5','boundary','shape',-
1,'LINESTRING',2);

I did this and got no error messages, but I can't get PostgreSQL to do

select count (*) from boundary where truly_inside ( GeometryFromText
('POLYGON ((78550000 457900000,78550000 458025000,78650000 
458025000,78650000 457900000,78550000 457900000))' ,-1 ) , bbox );

without using a Seq Scan even with 'set enable_seqscan=off;'. Or is 
this correct?





To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 





More information about the postgis-users mailing list