On Tue, Jan 02, 2001 at 05:01:56PM +0100, François LODIER wrote:
> Hi all,
>
> happy new year ,
>
> sorry to disturb you but I am trying to create a trigger but it doesn't seems to be working.
>
> I have got a function called halloworld that takes one argument and I am trying to trigger it :
>
> so I write somethig like :
>
> CREATE TRIGGER helloworld_trigger AFTER INSERT
> ON data FOR EACH ROW
> EXECUTE PROCEDURE helloworld ( 'login' )
>
> As I have a field named login in the data table.
>
> and the response is :
>
> CreateTrigger: function helloworld() does not exist
>
> If any ne could help me it would be great.
When triggers are called, they are invoked with no arguments. The
arguments listed in the "create trigger" statement are placed in the
array TG_ARGV[], which can be referenced inside your procedure.
Zach
--
xach@xach.com Zachary Beane http://www.xach.com/