Re: [INTERFACES] Tables names from query - Mailing list pgsql-interfaces

From tolik@icomm.ru (Anatoly K. Lasareff)
Subject Re: [INTERFACES] Tables names from query
Date
Msg-id 87hfsek63j.fsf@tolikus.hq.aaanet.ru
Whole thread Raw
In response to Tables names from query  (Philip Shiels <philip.shiels@jrc.it>)
List pgsql-interfaces
>>>>> "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

pgsql-interfaces by date:

Previous
From: Philip Shiels
Date:
Subject: Tables names from query
Next
From: Michael Contzen
Date:
Subject: What is SQLForeignKeys in ODBC-Driver