[development] node_db_rewrite_sql implementation breaks on pgsql

[Sammy Spets]

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