Rule - Mailing list pgsql-general

From sara_software@hotmail.com (sara_software)
Subject Rule
Date
Msg-id c05ff500.0111251630.9dd8127@posting.google.com
Whole thread Raw
Responses Re: Rule
Re: Rule
List pgsql-general
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.

but it doesn't seem to let me do this, of course all the documentation
leads me to believe it is not possible, but if I am able to call the
function from within an insert statement, can't I just skip that all
together and call the function alone?

Be gentle.

~Sara

pgsql-general by date:

Previous
From: sth@bsbg.net (Stefan Hadjistoytchev)
Date:
Subject: Problem parsing functions makes PgSQL Restore impossible
Next
From: Neil Zanella
Date:
Subject: Re: checking date format with postgresql without creating