View Single Post
  #9 (permalink)  
Old 07-29-09, 16:02
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,481
Quote:
Originally Posted by rski
cos in postgres it is not true .
it is so true!!!

you are getting confused

in postgresql, DISTINCT ON and DISTINCT are two completely separate things

i was talking about putting an expression into parentheses after the DISTINCT

DISTINCT ON is completely different semantics
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote