1-- 2-- LSEG 3-- Line segments 4-- 5 6--DROP TABLE LSEG_TBL; 7CREATE TABLE LSEG_TBL (s lseg); 8 9INSERT INTO LSEG_TBL VALUES ('[(1,2),(3,4)]'); 10INSERT INTO LSEG_TBL VALUES ('(0,0),(6,6)'); 11INSERT INTO LSEG_TBL VALUES ('10,-10 ,-3,-4'); 12INSERT INTO LSEG_TBL VALUES ('[-1e6,2e2,3e5, -4e1]'); 13INSERT INTO LSEG_TBL VALUES (lseg(point(11, 22), point(33,44))); 14INSERT INTO LSEG_TBL VALUES ('[(-10,2),(-10,3)]'); -- vertical 15INSERT INTO LSEG_TBL VALUES ('[(0,-20),(30,-20)]'); -- horizontal 16INSERT INTO LSEG_TBL VALUES ('[(NaN,1),(NaN,90)]'); -- NaN 17 18-- bad values for parser testing 19INSERT INTO LSEG_TBL VALUES ('(3asdf,2 ,3,4r2)'); 20INSERT INTO LSEG_TBL VALUES ('[1,2,3, 4'); 21INSERT INTO LSEG_TBL VALUES ('[(,2),(3,4)]'); 22INSERT INTO LSEG_TBL VALUES ('[(1,2),(3,4)'); 23 24select * from LSEG_TBL; 25