Problem with libpq in PostgreSQL 6.3.2:

I have a query that combines 2 tables, each with a column named id:

select a.*, b.* from organisation as a, individual as b
 where a.contact = b.id

I am finding that libpq is unable to distinguish between the two id columns,
because the 'a.' and 'b.' are apparently dropped by the backend before the
data is returned.  I could get the columns by number, or by explicitly
renaming columns, but that would require an awkward lack of flexibility
in the application.

Is this easy to fix? Is it desirable to fix it from the project's point
of view?  I know that column headings would be more awkward, but the
front end could easily strip those...

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "For yourselves know perfectly that the day of the Lord
      so cometh as a thief in the night. For when they shall
      say, Peace and safety; then sudden destruction cometh 
      upon them, as travail upon a woman with child; and 
      they shall not escape."      I Thessalonians 5:2,3 



Sat, 22 Aug 1998 17:58:02 +0100
"Oliver Elphick" <olly@lfix.co.uk>
Can I distinguish identically named columns in joined tables?