On 8/18/06, Paul Steinkamp <[EMAIL PROTECTED]> wrote:
Can't the same effect be achieved with GROUP BY?
-- Brandon
Greetings,
I'm using postgres as my DB which will accept the clause:
SELECT DISTINCT ON ( field1, ..., fieldn) fieldA, fieldB,...
FROM ....
Note there is no comma after the closing ')' after the 'DISTINCT ON'
clause. My various attempts either end up not getting it included at
all or included as a function (and therefore separated from the
selection field lists by a comma).
Is there a way within the class (short of raw SQL) to perform this
kind of select?
Can't the same effect be achieved with GROUP BY?
-- Brandon
_______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
