[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