search

OpenInformix / IfxPy

Informix native Python driver for scalable enterprise and IoT solutions.
Other
46 stars 22 forks source link

Columns with the same name #66

Open plitter opened 2 years ago

plitter commented 2 years ago

What do you suggest to do when you have 2 columns that have the same name in 2 tables, and you join those 2.

select 'bar' zar, 'foo' zar

fetch_assoc returns the last one. But is it possible to get a prefix/suffix(maybe table/alias prefix) or something so that it is more clear that there is more columns here?

plitter commented 2 years ago

This is becoming more and more annoying when I have to join the same table....