On Thu, Feb 21, 2008 at 09:10:56AM +1100, Neil Lunn wrote:
>
>
> Matt Lawrence wrote:
> >You can pass distinct => 1 to the attributes to affect a GROUP BY
> >clause containing all columns, which should be logically equivalent
> >to SELECT DISTINCT
> >
> >{
> > select => [ 'm2.inventorycategoryid', 'c2.name' ],
> > distinct => 1,
> >}
> >
> Yes I do remember seeing that in the docs now. Thanks for the pointer.
> I wonder what then is the purpose of this construct?
>
> {
> select => [ { distinct => [ $source->columns ] } ],
> }
>
> As the array ref is parsed into : select distinct( col1, col2) ??
Patches to generate the correct SQL are welcome.
I suspect because there's an alternative way that works anybody who would
have patched it has simply switched.
--
Matt S Trout Need help with your Catalyst or DBIx::Class project?
Technical Director http://www.shadowcat.co.uk/catalyst/
Shadowcat Systems Ltd. Want a managed development or deployment platform?
http://chainsawblues.vox.com/ http://www.shadowcat.co.uk/servers/
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
