Possible to create a *really* virtual table ? - Mailing list 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