| 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: | Whole Thread | Raw Message | 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
| 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 |