text: --
  -- 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], (s[0])[1];
  
  SELECT * FROM LSEG_TBL WHERE s <= lseg '[(1,2),(3,4)]' ORDER BY (s[0])[0], (s[0])[1];
  
  SELECT * FROM LSEG_TBL WHERE (s <-> lseg '[(1,2),(3,4)]') < 10 ORDER BY (s[0])[0], (s[0])[1];
  