Re: C++: headache with PgDatabase::GetValue (int, string) - Mailing list pgsql-interfaces

"Carlos Moreno" <moreno@mochima.com> writes:
> I have a SELECT statement that returns 
> data from both tables, and I need both Name fields: 

>     "select Emp.Name, Dept.Name from Emp, Dept where ....... "

> Now, I (obviously) want to use GetValue (row, "field_name") to 
> get the values. 

If you "obviously" want to use a fetch-by-name operation to fetch
fields, then it'd behoove you to name the columns differently in the
first place.  For example:
   select Emp.Name as emp_name, Dept.Name as dep_name from ...
        regards, tom lane