[sqlalchemy] Re: postgres POLYGON data type

2007-09-17 Thread sc0ttbeardsley
On Sep 17, 5:03 am, [EMAIL PROTECTED] wrote: > Has anyone added support for the POLYGON data type in PostgreSQL? If > so, is there any code that can be shared? I haven't seen POLYGON but the beginnings of such support is over at bycycle.org[1]. I'm interested in something similar for MySQL's spat

[sqlalchemy] alias table names with a self-ref join

2007-09-09 Thread sc0ttbeardsley
I'm newish to SQLAlchemy. I've been trying to do something for too long now so I'm posting here. I'm trying to implement a tree in sql. I've seen the example here[1] but I prefer to implement trees using this method[2] (it's cleaner and more elegant). I'm stuck doing the following join (to get th