[Zope-dev] dupe column names not supported (Shared.DC.ZRDB) ?

Adam Manock abmanock@earthlink.net
17 Dec 2002 15:03:43 -0500


> Just for curiousity, what is the use case for returning multiple columns with 
> the same name? Sounds dubious to me.

A self join will return multiple columns with the same name unless AS
keyword is used. The use of AS keyword is supposed to be optional.
Assuming that a user does use AS, labeling of the returned columns will
be at the discretion of the user, and therefore again not guaranteed to
be unique.

I would guess that if Zope assumes that column names are unique,
changing that assumption now would be a major p.i.t.a. :-)

Adam