Re: Rule

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
-----------------------------------------------------------------