Re: libpq++: how do I qualify by table name a resulting field when there are duplicate field names - Mailing list pgsql-general

On Wed, Mar 21, 2001 at 10:59:41AM -0500, Nicolae wrote:
...
> SELECT * FROM customers, deals WHERE customers.number = deals.customernumber
> AND customers.number = 1;
>
> When I do
>
> database->GetValue (0, "number");
>
> I get back the number field of the customer table.
>
> But I want the number field from the deal table too.
> How do I get it?
>
> database->GetValue (0, "deals.number")
>
> gives me an error.

How about

SELECT customers.number,deals.number FROM customers,deals
 WHERE customers.number = deals.customernumber
   AND customers.number = 1

database->GetValue(0,0)  (I think it starts at 0..) == customers.number
database->GetValue(0,1) == deals.number

?

Cheers,

Patrick