Postgres-backed trac installations fail due to IFNULL not existing

[brian]

Postgres Trac installations do not have an IFNULL function which is used in the SQL query. Instead, you must change it to COALESCE() which will have the same effect in this instance:

"ORDER BY (coalesce(due, 0) = 0) ASC, due ASC, name" % time()

[cadiolis@…]

Postgresql syntax is NULLIF (versus IFNULL)

"ORDER BY (NULLIF(due, 0) = 0) ASC, due ASC, name" % time()

[Matt Good]

(In [796]) * use the Milestone model API to be cross-DB compatible and preserve proper sorting (fixes #158, #213, #235, #398)

• use Markup to make sure HTML is properly escaped for output