Content-Type: text/plain;
  charset="iso-8859-1"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: Tomasz Myrta <jasiek@klaster.net>,
	PGSQL-SQL <pgsql-sql@postgresql.org>
Subject: Re: virtual table
Date: Mon, 23 Jun 2003 09:29:23 +0100
User-Agent: KMail/1.4.3
References: <3EF61E44.2020601@klaster.net>
In-Reply-To: <3EF61E44.2020601@klaster.net>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200306230929.24372.dev@archonet.com>

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 =3D 1 row from table2, but sometimes 1 row from table1=3D 3 r=
ows
> 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=20
update/inserts.

--=20
  Richard Huxton