Re: [GENERAL] insert into view !! - Mailing list pgsql-general

From Howie
Subject Re: [GENERAL] insert into view !!
Date
Msg-id Pine.LNX.3.96.990623185836.12052B-100000@rabies.toodarkpark.org
Whole thread Raw
In response to insert into view !!  ("abdelkrim" <haj@idianet.net>)
List 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@toodarkpark.org>   URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."


pgsql-general by date:

Previous
From: Sascha Schumann
Date:
Subject: Re: [GENERAL] Readline library
Next
From: "Matt Magoffin (Borders Online)"
Date:
Subject: ERROR: typeidTypeRelid: Invalid type - oid = 0