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
_______________________________________________
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )
