Hello,
I want to use LIMIT and OFFSET with the UNION construct. Using keyword
arguments to the union function, like
union(
select([foo.c.id, foo.c.timestamp]),
select([bar.c.id, bar.c.timestamp]),
order_by = ['timestamp DESC'],
limit = 10,
offset = 10,
)
didn't work. What i ended up with is:
union(
select([foo.c.id, foo.c.timestamp]),
select([bar.c.id, bar.c.timestamp]),
order_by = ['timestamp DESC LIMIT 10 OFFSET 10'],
)
Is there a more clean way to do this. Did I miss something?
--
Cheers, Sol.
-------------------------------------------------------------------------
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
