From d2ed308da38af01e23d9f4085f6b8f973994b29a Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Fri, 17 Aug 2012 19:11:21 -0400 Subject: [PATCH] add a note --- examples/postgis/postgis.py | 3 +++ 1 file changed, 3 insertions(+) diff --git a/examples/postgis/postgis.py b/examples/postgis/postgis.py index ef9b77c81c..0b86ad323d 100644 --- a/examples/postgis/postgis.py +++ b/examples/postgis/postgis.py @@ -253,6 +253,9 @@ if __name__ == '__main__': stmt = select([road_table]).where(road_table.c.road_geom.intersects(r1.road_geom)) print session.execute(stmt).fetchall() + # TODO: for some reason the auto-generated labels have the internal replacement + # strings exposed, even though PG doesn't complain + # look up the hex binary version, using SQLAlchemy casts as_binary = session.scalar(select([type_coerce(r.road_geom, Geometry(coerce_="binary"))])) assert as_binary.as_hex == \ -- 2.47.3