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(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------