Re: trigger or something else?

From: Grant Finnemore <gaf(at)ucs(dot)co(dot)za>
To: "Anatoly K(dot) Lasareff" <tolik(at)aaanet(dot)ru>
Cc: Emils Klotins <emils(at)dot(dot)lv>, pgsql-sql(at)postgresql(dot)org
Subject: Re: trigger or something else?
Date: 2000-07-03 09:34:46
Message-ID: 39605E36.589B6F35@ucs.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> I suppose you can use view for your need. For example:
>

...

> Unfortunately this way suits for select only, not for 'insert into b'
> and 'update b' statement.
>

Except that you can use rules to update/insert data into tables when an
insert/update is done on the view. See the docs for details on how to do this.

>
> --
> Anatoly K. Lasareff Email: tolik(at)aaanet(dot)ru

Grant

--
> Poorly planned software requires a genius to write it
> and a hero to use it.

Grant Finnemore BSc(Eng) (mailto:gaf(at)ucs(dot)co(dot)za)
Software Engineer Universal Computer Services
Tel (+27)(11)712-1366 PO Box 31266 Braamfontein 2017, South Africa
Cell (+27)(82)604-5536 20th Floor, 209 Smit St., Braamfontein
Fax (+27)(11)339-3421 Johannesburg, South Africa

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-07-03 14:16:51 Re: Antw: plpgsql function gets wierd with Null parameters
Previous Message Gerhard Dieringer 2000-07-03 07:42:54 Antw: plpgsql function gets wierd with Null parameters