| -- |
| -- LSEG |
| -- Line segments |
| -- |
| |
| --DROP TABLE LSEG_TBL; |
| CREATE TABLE LSEG_TBL (s lseg); |
| |
| INSERT INTO LSEG_TBL VALUES ('[(1,2),(3,4)]'); |
| INSERT INTO LSEG_TBL VALUES ('(0,0),(6,6)'); |
| INSERT INTO LSEG_TBL VALUES ('10,-10 ,-3,-4'); |
| INSERT INTO LSEG_TBL VALUES ('[-1e6,2e2,3e5, -4e1]'); |
| INSERT INTO LSEG_TBL VALUES ('(11,22,33,44)'); |
| |
| -- bad values for parser testing |
| INSERT INTO LSEG_TBL VALUES ('(3asdf,2 ,3,4r2)'); |
| INSERT INTO LSEG_TBL VALUES ('[1,2,3, 4'); |
| INSERT INTO LSEG_TBL VALUES ('[(,2),(3,4)]'); |
| INSERT INTO LSEG_TBL VALUES ('[(1,2),(3,4)'); |
| |
| select * from LSEG_TBL ORDER BY (s[0])[0]; |
| |
| SELECT * FROM LSEG_TBL WHERE s <= lseg '[(1,2),(3,4)]' ORDER BY (s[0])[0]; |
| |
| SELECT * FROM LSEG_TBL WHERE (s <-> lseg '[(1,2),(3,4)]') < 10 ORDER BY (s[0])[0]; |
| |