pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tomasz Myrta <jasiek@klaster.net>
To: Richard Huxton <dev@archonet.com>
Cc: PGSQL-SQL <pgsql-sql@postgresql.org>
Subject: Re: virtual table
Date: Mon, 23 Jun 2003 10:39:16 +0200
Message-ID: <3EF6BCB4.2040209@klaster.net> (raw)
In-Reply-To: <200306230929.24372.dev@archonet.com>
References: <3EF61E44.2020601@klaster.net>
	<200306230929.24372.dev@archonet.com>

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




view thread (6+ messages)  latest in thread

Message-ID: <3EF6BCB4.2040209@klaster.net>
Permalink:  ../3EF6BCB4.2040209@klaster.net/
Also on:    postgresql.org/message-id/3EF6BCB4.2040209@klaster.net

 · 

reply

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, dev@archonet.com
  Subject: Re: virtual table
  In-Reply-To: <3EF6BCB4.2040209@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