[Twisted-Python] twisted.news adbapi backend
Stephen C. Waterbury
golux at comcast.net
Thu Sep 25 20:55:01 MDT 2003
I'm guessing this has never been used (at least with
pyPgSQL, anyway), since it has a function listRequest
defined thusly:
def listRequest(self):
# COALESCE may not be totally portable
# it is shorthand for
# CASE WHEN (first parameter) IS NOT NULL then (first
parameter) ELSE (second parameter) END
sql = """
SELECT groups.name,
COALESCE(MAX(postings.article_index), 0),
COALESCE(MIN(postings.article_index), 0),
groups.flags
FROM groups LEFT OUTER JOIN postings
ON postings.group_id = groups.group_id
GROUP BY groups.name, groups.flags
ORDER BY groups.name
"""
return self.runQuery(sql)
... but PostgreSQL doesn't implement a COALESCE command.
And my next guess would be that it's never been tested,
either. Correct?
If so, maybe it should be either be fixed or jettisoned,
or at least relegated to the sandbox.
- Steve.
More information about the Twisted-Python
mailing list