[DB-SIG] Result Set Inconsistencies

[Chris Cogdon]

On Wednesday, Jul 16, 2003, at 11:36 US/Pacific, Orr, Steve wrote:

> Why the inconsistencies in .fetch* result sets?
>
> Module    fetchall Result Set
> --------- -------------------
> MySQLdb   tuple of tuples
> cx_Oracle list of tuples
> DCOracle2 list of lists

The DB-API2.0 specification specifies that 'sequences' be used. This 
can mean tuples, lists or any other type that mimics the sequence 
protocol. For Example, pyPgSQL returns a list of PgResultSets, which 
operate like a sequence, but have other attributes too).

Therefore, there is no requirement to specifically use lists or tuples, 
so the implementer is free to implement how he or she sees fit.

-- 
    ("`-/")_.-'"``-._        Chris Cogdon <chris at cogdon.org>
     . . `; -._    )-;-,_`)
    (v_,)'  _  )`-.\  ``-'
   _.- _..-_/ / ((.'
((,.-'   ((,/   fL