Same problem has been reported with Oracle 8.1, since it too will return duplicate names. The SQL92 spec is a bit ambiguous about whether all returned column names must be unique.
Ross On Tue, Dec 17, 2002 at 01:09:13PM -0500, Adam Manock wrote: > > specifically with: > > SELECT W1.city, W1.temp_lo AS low, W1.temp_hi AS high, > W2.city, W2.temp_lo AS low, W2.temp_hi AS high > FROM weather W1, weather W2 > WHERE W1.temp_lo < W2.temp_lo > AND W1.temp_hi > W2.temp_hi; > > > Error, exceptions.ValueError: Duplicate column name, city > > Traceback (innermost last): > Module ZPublisher.Publish, line 98, in publish > Module ZPublisher.mapply, line 88, in mapply > Module ZPublisher.Publish, line 39, in call_object > Module Shared.DC.ZRDB.Connection, line 115, in manage_test > Module Shared.DC.ZRDB.Results, line 52, in __init__ > ValueError: Duplicate column name, city _______________________________________________ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )