| From: | Howie <caffeine(at)toodarkpark(dot)org> |
|---|---|
| To: | abdelkrim <haj(at)idianet(dot)net> |
| Cc: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | Re: [GENERAL] insert into view !! |
| Date: | 1999-06-23 19:00:00 |
| Message-ID: | Pine.LNX.3.96.990623185836.12052B-100000@rabies.toodarkpark.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 23 Jun 1999, abdelkrim wrote:
> it is possible to insert into a view ?
if its a single-table view, yes -- you'd want to create a DO INSTEAD rule.
consult the manual/html pages to get the proper syntax for CREATE RULE.
if its a multitable view, maybe... i dont think this can be done with a
single rule, however. you'll most likely need to implement a pl/pgsql or
pl/tcl function.
---
Howie <caffeine(at)toodarkpark(dot)org> URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1999-06-23 19:05:04 | Re: [GENERAL] ERROR: typeidTypeRelid: Invalid type - oid = 0 |
| Previous Message | David R. Favor | 1999-06-23 18:58:02 | Re: [GENERAL] ERROR: typeidTypeRelid: Invalid type - oid = 0 |