On Mon, Jun 04, 2001 at 11:12:56PM +0200, Rasmus Resen Amossen wrote:
> If I add a "where" clause on my views, I can't insert or update them
> anymore. Why?
>
> Example:
> CREATE TABLE temp (a int);
> CREATE VIEW tview AS SELECT a FROM temp WHERE a>10;
>
> INSERT INTO tview VALUES (13);
> ERROR:
If I add a "where" clause on my views, I can't insert or update them
anymore. Why?
Example:
CREATE TABLE temp (a int);
CREATE VIEW tview AS SELECT a FROM temp WHERE a>10;
INSERT INTO tview VALUES (13);
ERROR: Cannot update a view without an appropriate rule
What is the appropriate rule?
--
R
