Skip site navigation (1) Skip section navigation (2)

Rules

From: "Peeter Smitt" <peeter(dot)smitt(at)online(dot)ee>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Rules
Date: 2000-11-09 08:50:44
Message-ID: 002d01c04a2a$262f2680$6f646ac2@miniraket (view raw or flat)
Thread:
Lists: pgsql-sql
Hi 

I'm trying to make updateable view useing rules.

CREATE RULE update_rule AS ON UPDATE TO table DO INSTEAD
  SELECT fun1(new);

Thing is that backend gives this error.
  ERROR:  parser: parse error at or near ")"

What i'm doing wrong? Are there any other ways to make updatebale multi-table views?

thanks and joyfull new year.

-----------------------------------------
Peeter Smitt
AS Delfi Online
Pärnu mnt. 158
11317 Tallinn, Estonia
Tel +3726501734
GSM +37256647653
peeter(dot)smitt(at)online(dot)ee
www.delfi.ee

Responses

  • Re: Rules at 2000-12-31 12:18:30 from Peter Eisentraut
  • Re: Rules at 2001-01-02 23:51:07 from Jan Wieck

pgsql-sql by date

Next:From: hubert depesz lubaczewskiDate: 2000-11-09 13:20:36
Subject: how to write it in most efficient way?
Previous:From: Antti LinnoDate: 2000-11-09 08:41:54
Subject: Re: insert value of form - checkboxes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group