[Twisted-Python] twisted.news adbapi backend
Stephen C. Waterbury
golux at comcast.net
Thu Sep 25 22:55:01 EDT 2003
I'm guessing this has never been used (at least with
pyPgSQL, anyway), since it has a function listRequest
# 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 = """
FROM groups LEFT OUTER JOIN postings
ON postings.group_id = groups.group_id
GROUP BY groups.name, groups.flags
ORDER BY groups.name
... but PostgreSQL doesn't implement a COALESCE command.
And my next guess would be that it's never been tested,
If so, maybe it should be either be fixed or jettisoned,
or at least relegated to the sandbox.
More information about the Twisted-Python