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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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