Quote:
|
Originally Posted by rski
I'm afraid it is not true. Distinct do not have to aplly to all columns, if you use
then distinct will apply only to those column you write in parentheses |
yes, but....
Quote:
|
Originally Posted by da postgresql manual
The DISTINCT ON clause is not part of the SQL standard and is sometimes considered bad style because of the potentially indeterminate nature of its results.
|
my advice is to stay away from non-standard SQL unless there is a real good reason
and this aint one of them
