|
From: SourceForge.net <no...@so...> - 2007-02-05 19:31:13
|
Bugs item #1652661, was opened at 2007-02-05 17:31 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1652661&group_id=74338 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Postgres Group: SQLObject release (specify) Status: Open Resolution: None Priority: 5 Private: No Submitted By: Elvis Pfutzenreuter (epx) Assigned to: Nobody/Anonymous (nobody) Summary: orderBy with negative sign does not work for DateCol's Initial Comment: Version: SQLObject-0.7.3-py2.4.egg While using select(..., orderBy=-datecolumn) works for MySQL, it fails for PostgreSQL. The report error is: ERROR: operator does not exist: - timestamp without time zone\nHINT: No operator matches the given name and argument type(s). You may need to add explicit type casts. Probably Postgres does not like arithmetic operations with timestamps/dates. Removing the negative sign and doing select(orderby=datecolumn).reversed() works just fine. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1652661&group_id=74338 |
