Possible to create a *really* virtual table ?

From: Denis Bucher <dbucher(at)niftycom(dot)com>
To: PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Possible to create a *really* virtual table ?
Date: 2001-11-05 14:02:11
Message-ID: 5.1.0.14.0.20011105150016.00a91070@mail.niftycom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hello !

Is it possible to create a virtual table, NOT a view ?

For example :

SELECT *
FROM
(VALUES ('orange', 'orange'), ('apple', 'red'),
('banana', 'yellow'))
AS Fruits_And_Colors(fruit, color);

I.e. to do a request on a non-real table ?

I want to have the following virtual table :

TABLE b
id | b
------------
1 | 't'
2 | 'f'

Is it possible in PostgreSQL ?

Thanks a lot for any help

Denis Bucher

Browse pgsql-sql by date

  From Date Subject
Next Message Janning Vygen 2001-11-05 14:58:26 Design Tool for postgresql
Previous Message Nikhil G. Daddikar 2001-11-05 05:17:25 Generating list of days in a given time interval