Is it possible to work with set-returning functions in SQLAlchemy
without using raw SQL? For example, the PostgreSQL/PostGIS function
ST_Dump (http://bit.ly/culek7) returns a “geometry_dump" set. Using
ST_Dump in raw SQL goes something like:
SELECT
ST_Dump(ST_Intersection(data_table1.geom,data_table2.geom)).geom AS
geom...
In SQLAlchemy an attempt to construct this unsurprisingly yields an
attribute error:
session.query(func.ST_Dump(functions.intersection(Data1.geom,Data2.geom).geom.label('geom'))
AttributeError: 'Function' object has no attribute 'geom'
Curious if anyone knows a solution! A search for using set-returning
functions in SQLAlchemy yielded no obvious solution...
Thanks in advance.
--
Ben Koziol
Michigan Tech Research Institute (MTRI)
Ann Arbor, MI
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
