perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Vanasco <>
Subject Re: [RFC PATCH BUG DBI] Apache::AuthDBI broken
Date Tue, 04 Apr 2006 00:53:28 GMT

On Apr 3, 2006, at 8:19 PM, wrote:

> I don't think there's any down-side to adding DISTINCT.  (Is it  
> standard
> sql?  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.

View raw message