Igor Tandetnik wrote: > Christophe Leske <[EMAIL PROTECTED]> wrote: >> can someone remember me how to fill in a rtree table with values from >> another table? >> >> Something like >> >> insert into lookup (select id, x,y from othertable) -- this doesnt >> work btw > > insert into lookup(idField, xField, yField) > select id, x, y from othertable; > > Use actual field names in lookup table for idField, xField and yField. >
You must use ranges for each dimension in the rtree table. If your original table only has points, you need to duplicate the point data to generate a range of zero length. insert into lookup(idField, xmin, xmax, ymin, ymax) select id, x, x, y, y from othertable; HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
