[Postgresql] Circle 및 Polygon 공간연산

Circle 공간 연산

select * from tt
where 1 = 1
and st_contains( ST_Buffer( ST_SetSRID(ST_Point(#{xAxis},#{yAxis}),6645) , #{radius}) ,shape) = true

 

Polygon 공간 연산

select * from tt
where 1 = 1
and st_contains(  ST_SetSRID(ST_GeomFromText(#{drawWkt}),6645)  ,shape) = true