ST_Transform error

Question

I am getting an error from ST_Tranform while using ST_Intersection: No function matches the given name and argument types. You might need to add explicit type casts.

select ST_Intersection(ST_Transform(ST_GeomFromText('POLYGON((
200000 2900000,250000 3500000,300000 2960000,200000 2967400,200000 
2900000))',96703),4326), ST_Transform((geom, 2249), 4326))
from polygon_folder;

Answer 1

You probably want to do this:

  select ST_Intersection(
  ST_Transform(
      ST_SetSRID(ST_GeomFromText('POLYGON((
    200000 2900000,250000 3500000,300000 2960000,200000 2967400,200000 
    2900000))'),96703),4326), 

ST_Transform(geom, 4326))
from polygon_folder;

But, I am quite sure (from Finding all polygons inside of a polygon) that ST_Intersection is not really what you need....