Re: C++: headache with PgDatabase::GetValue (int, string)

"Carlos Moreno" <moreno(at)mochima(dot)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