From: Denis Bucher <dbucher@niftycom.com>
To: PGSQL-SQL <pgsql-sql@postgresql.org>
Subject: Possible to create a *really* virtual table ?
Date: Mon, 05 Nov 2001 15:02:11 +0100
Message-ID: <5.1.0.14.0.20011105150016.00a91070@mail.niftycom.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dbucher@niftycom.com
Subject: Re: Possible to create a *really* virtual table ?
In-Reply-To: <5.1.0.14.0.20011105150016.00a91070@mail.niftycom.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox