Re: virtual table

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: virtual table
Date: 2003-06-23 08:39:16
Message-ID: 3EF6BCB4.2040209@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dnia 2003-06-23 10:29, Użytkownik Richard Huxton napisał:
> Look into views - you'll need to provide triggers to handle the
> update/inserts.
I think view won't change too much - there is not too much difference for this
case between creating view and empty table with trigger returning null.
I was thinking about something more comfortably - table without pre-declared
columns so I don't have to change table definition when pl/pgsql function changes.

Can anyone tell me how triggers work? Do they need to look into table column
definition to retrieve data?

Regards,
Tomasz Myrta

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2003-06-23 08:54:54 Re: virtual table
Previous Message Richard Huxton 2003-06-23 08:29:23 Re: virtual table