perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Vanasco <...@2xlp.com>
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, pedersen@meridian-enviro.com 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.

Mime
View raw message