| 1 | | create table test(id integer, bounding_box box); |
| 2 | | copy test from 'randomboxes' delimiter ';' ; |
| 3 | | create index boxix on test using gist (bounding_box box_ops); |
| | 1 | create table test(id integer, the_box box); |
| | 2 | copy test from '/home/cc/cs186/fa07/coass/cs186-XX/Hw2/MyStuff/randomboxes' delimiter ';' ; |
| | 3 | create index ix1 on test using gist (the_box box_ops); |
| | 4 | create table test25 (id integer, the_box box); |
| | 5 | copy test25 from '/home/cc/cs186/fa07/class/cs186-XX/Hw2/MyStuff/randomboxes25' delimiter ';' ; |
| | 6 | create index ix2 on test25 using gist (the_box box_ops); |
| | 7 | create table cali(location box, name text); |
| | 8 | copy cali from '/home/cc/cs186/fa07/class/cs186-XX/Hw2/MyStuff/cali.txt' delimiter '|'; |
| | 9 | create index cali_ix on cali using gist(location box_ops); |
