[DB-SIG] Re: May we get an actual ANSWER to the F.A.Q...How c an I construct a dictionary???

[Dittmar, Daniel]

> > - there are those nitpickers who say that column names aren't 
> > necessarily unique and that the uppercase/lowercase issues 
> make it worse
> 
> Heh, that's funny. Never thought of that, but it is 
> certainly true for DB2. I just tried 
[...]
> How odd! I had assumed that this would be an error. On the
> other hand, I don't really see why anyone would like to do that

This mostly happens when joining tables and similar named
columns appear in both tables.

SAP DB did complain, but we had
to become more lenient as applications that were
ported from other databases were actually generating
such result sets.

> that, and I could accept that a tuple -> dict tool would
> fail silently on something like this. I haven't tried this
> with db_row etc...

One more implementation defined feature (how to resolve duplicate
column names) probably won't make that much of a difference.

Daniel 

-- 
Daniel Dittmar
SAP DB, SAP Labs Berlin
daniel.dittmar at sap.com
http://www.sapdb.org/