point와 lseg로 만들어 본 질의 입니다.....잘 만든 것인지 알고 싶어서요..

(1,1) (10,10)사이의 점 좌표만 추출해 내기

test=> select p from geoline4 where geoline4.p >^ '(1,1)'::point AND geoline4.p >> '(1,1)'::point AND geoline4.p <^ '(10,10)'::point AND

geoline4.p << '(10,10)'::point;

(1,1) (10,10)사이의 lseg만 추출해 내기

test=> select p from geoline4 where geoline4.p >^ '((1,1)(10,1))'::lseg AND geoline4.p >> '((1,1)(1,10))'::lseg and geoline4.p <^ '((1,10)(10,10))'::lseg AND geoline4.p << '((10,1),(10,10))'::lseg;