Re: trigger or something else? - Mailing list pgsql-sql

From Grant Finnemore
Subject Re: trigger or something else?
Date
Msg-id 39605E36.589B6F35@ucs.co.za
Whole thread Raw
In response to trigger or something else?  ("Emils Klotins" <emils@dot.lv>)
List 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@aaanet.ru

Grant

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

Grant Finnemore BSc(Eng)  (mailto:gaf@ucs.co.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





pgsql-sql by date:

Previous
From: "Gerhard Dieringer"
Date:
Subject: Antw: plpgsql function gets wierd with Null parameters
Next
From: emils@dot.lv
Date:
Subject: ...