To: philip.shiels@jrc.it
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Tables names from query
References: <36D15B0D.B57DB69C@jrc.it>
Mime-Version: 1.0 (generated by tm-edit 7.108)
Content-Type: text/plain; charset=US-ASCII
From: tolik@icomm.ru (Anatoly K. Lasareff)
Date: 22 Feb 1999 14:53:04 +0300
In-Reply-To: Philip Shiels's message of "Mon, 22 Feb 1999 14:26:37 +0100"
Message-ID: <87hfsek63j.fsf@tolikus.hq.aaanet.ru>
Lines: 15

>>>>> "PS" == Philip Shiels <philip.shiels@jrc.it> writes:

 PS> I'm currently developing a postgres DB backend to my current project and have
 PS> the following problem. If I execute a query I need to know the table the
 PS> returning fields belong to. For example :

 PS> SELECT x.y, z.y from x, y where x.key = z.key

select x.y as xy, z.y as zy from x, y where x.key = z.key
           ^^^^^      ^^^^^
????

-- 
Anatoly K. Lasareff              Email:       tolik@icomm.ru 
Senior programmer