[development] node_db_rewrite_sql implementation breaks on pgsql

Hi everyone, It appears there is a _very_ serious implementation flaw with node_db_rewrite_sql() in that it fails (very) miserably on pgsql. It occurs when fields in ORDER BY clauses aren't placed in the list of selected fields. There is a patch available (posted by @smsimms - thanks!) to repair this problem. It uses a subquery to solve the problem cleanly. We need some input on the solution and some testing done on mysql. See: http://drupal.org/node/76819 Cheers, -- Sammy Spets Synerger Pty Ltd http://synerger.com