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]

In reply to Re^7: Combine data in table by davidrw
in thread Combine data in table by DrAxeman

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.