Re: Tablenames in Resultsets?

From: Papp Gyozo <s7461pap(at)hszk(dot)bme(dot)hu>
To: gb(at)a3design(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Tablenames in Resultsets?
Date: 2000-09-27 11:20:16
Message-ID: Pine.GSO.4.21.0009271310010.18676-100000@ural2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

instead of
> select * from test1, test2 where test1.id=test2.id
use

SELECT test1.id AS "test1.id", test1.value, test2.id AS "test2.id",
test2.value FROM test1 , test2 WHERE test1.id = test2.id;

Papp Gyozo

s7461pap(at)hszk(dot)bme(dot)hu, gerzson17(at)freemail(dot)hu

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Good 2000-09-27 12:48:58 Re: Re: web programming
Previous Message Philip Warner 2000-09-27 11:10:12 Change of behaviour of pg_get_userbyid & pg_get_viewdef - do it?