On Apr 3, 2006, at 8:19 PM, [EMAIL PROTECTED] wrote:
I don't think there's any down-side to adding DISTINCT. (Is it standardsql? I think it probably is, but I don't have a reference.) If there is, it would be worth adding another yes/no knob to the config.
SELECT DISTINCT behaves radically differnet in mysql and postgres. postgres requires all of the column names to be explicitly declared. mysql seems to do some automagic grouping when it aggregates the info.
