Q:

ST_Transform error

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;

A:

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....

