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