When using the distinct option with a declared-sql query and Postgres 7.3, there is an issue if one wishes to sort by an additional key. According to the query generated by JBoss, it only queries for the primary key on the first query.
Postgresql however, requires all fields in the "order by" to be present in the field list being selected. How can I work around this, or is this an additional option that needs developing?
Robert
