From: Tomasz Myrta <jasiek@klaster.net>
To: PGSQL-SQL <pgsql-sql@postgresql.org>
Subject: virtual table
Date: Sun, 22 Jun 2003 23:23:16 +0200
Message-ID: <3EF61E44.2020601@klaster.net> (raw)
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.
Regards,
Tomasz Myrta
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: jasiek@klaster.net
Subject: Re: virtual table
In-Reply-To: <3EF61E44.2020601@klaster.net>
* 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