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?
Thanks,
Paul
_______________________________________________
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]/
