Re^7: Combine data in table

doh. after all this, 'GROUP BY' isn't supported by DBD::CSV ... following is from the cb:

davidrw 2005-08-07 16:03:24-04
    jZed (or anyone) did you see 481726 and replies? Any reason that a
+ "GROUP BY" sql statement wouldn't work w/DBD::CSV ?
bart 2005-08-07 16:05:53-04
    Because it didn't get implemented?
castaway 2005-08-07 16:06:22-04
    always a good reason ;)
davidrw 2005-08-07 16:08:10-04
    not implemented? doh! is that a guess or a fact?
davidrw 2005-08-07 16:08:59-04
    davidrw goes to skim DBD::CSV docs for known bugs/limitations
davidrw 2005-08-07 16:10:24-04
    davidrw doesn't find anything obvious in DBD::CSV or DBD::File pod
Zaxo 2005-08-07 16:12:43-04
    since there isn't a db daemon managing things, constructs like tha
+t have to be written from scratch in DBD::CSV
castaway 2005-08-07 16:13:25-04
    right
Corion 2005-08-07 16:13:41-04
    Hmmm. "Group By" would likely be a hash filter sitting between the
+ row-scanner and the aggregator function(s)
Corion 2005-08-07 16:14:03-04
    ... so it "shouldn't be hard". But then, what do I know about DBDs
+ :)
davidrw 2005-08-07 16:14:24-04
    hmm.. true.
davidrw 2005-08-07 16:15:15-04
    i wonder if any other non-db-daemon DBD:: modules implement GROUP 
+BY?
Zaxo 2005-08-07 16:16:32-04
    Berkeley might, but I don't know
Corion 2005-08-07 16:17:55-04
    davidrw: SQLite does. :)
davidrw 2005-08-07 16:18:42-04
    ah. y, i knew that -- i use it a lot :)
davidrw 2005-08-07 16:18:52-04
    it's been a slow lazy sunday ...
[download]

Comment on Re^7: Combine data in table Download Code

Replies are listed 'Best First'.
Re^8: Combine data in table by CountZero (Bishop) on Aug 07, 2005 at 20:30 UTC
But is does work! At least in version 0.22 of DBD::CSV. CountZero "If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law	[reply]
Re^8: Combine data in table by jZed (Prior) on Aug 08, 2005 at 02:52 UTC
doh. after all this, 'GROUP BY' isn't supported by DBD::CSV Sorry, you're mistaken, it is supported. See my reply elsewhere in this thread. The place to look for the SQL syntax supported by DBD::CSV is in SQL::Statement::Syntax. GROUP BY has been supported for the past several releases, but I'd recommend getting the latest release (of SQL::Statement) in any case.	[reply]