"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
In response to
pgsql-interfaces by date
|Next:||From: Hiroshi Inoue||Date: 2002-02-18 00:36:16|
|Subject: Re: odbc on unix|
|Previous:||From: Peter Eisentraut||Date: 2002-02-17 21:16:25|
|Subject: Re: C++: headache with PgDatabase::GetValue (int,|