[Zope] duplicate column name

Ivan Cornell ivan.cornell@framestore.co.uk
Thu, 07 Dec 2000 12:52:02 +0000


Olaf Zanger wrote:

> i work with postgreSQL 7.0.2, ZPyGreSQLDA-0-0-3 and zope 2.2.2 on suse
> 7.0 linux
>
> when i try the line
>
> -> select adr.id,fac.id from fac, adr
>

You probably need to alias the columns:
select adr.id as adr_id, fac.id as fac_id from fac, adr
and then refer to adr_id & fac_id from zope.

[can't remember why, but think it is due to the way columns are addressed
in libpq]

Ivan