From: Richard Huxton <dev@archonet.com>
To: Tomasz Myrta <jasiek@klaster.net>
To: PGSQL-SQL <pgsql-sql@postgresql.org>
Subject: Re: virtual table
Date: Mon, 23 Jun 2003 09:29:23 +0100
Message-ID: <200306230929.24372.dev@archonet.com> (raw)
In-Reply-To: <3EF61E44.2020601@klaster.net>
References: <3EF61E44.2020601@klaster.net>
On Sunday 22 Jun 2003 10:23 pm, Tomasz Myrta wrote:
> Hi
> I have another virtual problem, currently without any examples ;-)
>
> Let's say we have some pl/pgsql function which puts result into table1.
> This flat table must be normalized and put into table2. Sometimes 1 row
> from table1 = 1 row from table2, but sometimes 1 row from table1= 3 rows
> from table2. Data from table1 are transferrend into table2 using triggers.
> I found, I don't to have any data in table1.
> The question is: Is it possible to create virtual table in Postgresql?
> Virtual - means it won't contain any columns nor data, but trigger doing
> all the job.
Look into views - you'll need to provide triggers to handle the
update/inserts.
--
Richard Huxton
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: dev@archonet.com, jasiek@klaster.net
Subject: Re: virtual table
In-Reply-To: <200306230929.24372.dev@archonet.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