Hi,
"Having" clause needs to be before "Order by" for postgresql.
Index: ansisql.py
===================================================================
--- ansisql.py (revision 1387)
+++ ansisql.py (working copy)
@@ -371,15 +371,15 @@
if group_by:
text += " GROUP BY " + group_by
- order_by = self.get_str(select.order_by_clause)
- if order_by:
- text += " ORDER BY " + order_by
-
if select.having is not None:
t = self.get_str(select.having)
if t:
text += " \nHAVING " + t
+ order_by = self.get_str(select.order_by_clause)
+ if order_by:
+ text += " ORDER BY " + order_by
+
text += self.visit_select_postclauses(select)
if select.for_update:
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
