Re: Rule - Mailing list pgsql-general

From Martín Marqués
Subject Re: Rule
Date
Msg-id Pine.GSO.4.33.0111261158430.895-100000@bugs.unl.edu.ar
Whole thread Raw
In response to Rule  (sara_software@hotmail.com (sara_software))
List pgsql-general
On 25 Nov 2001, sara_software wrote:

> How can a rule call a function?
>
> I have found that I can do this:
>
> CREATE RULE a_rule
> AS ON INSERT TO a_table
> DO INSTEAD  INSERT into other_table(myfunction());
>
> actually I don't have any need for this test scenerio what I want to
> do is say:
>
> DO INSTEAD function();
> where all insert changes and testing will be carried out.

Use a trigger. :-)


Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Rule
Next
From: "Marc G. Fournier"
Date:
Subject: Re: [HOSTING QUESTION] - Advice on a decent PostgreSQL