Postgres Pro
Downloads
Home   >   mailing lists

Re: require some suggestion to write trigger function - Mailing list pgsql-novice

From jr
Subject Re: require some suggestion to write trigger function
Date
Msg-id h839am$6ra$1@news.hub.org
Whole thread Raw
In response to require some suggestion to write trigger function  (Jignesh Shah <jignesh.shah1980@gmail.com>)
List pgsql-novice
Tree view 
hi

> I have hard coded the columns name c1, c2, c3. Is it possible to get rid
> of hard coding c1, c2 and c3 so that I can use same my_trigger function
> for Foo2(x1, x2, x3) as well? Any suggestion would be really helpful for me.

read manual re. OLD.* and NEW.* variables.

--

regards, jr.  (jr@tailorware.org.uk)

pgsql-novice by date:

Previous
From: Sergey Samokhin
Date:
Subject: Re: Can't understand how a query from the documentation works
Next
From: "Doug Pisarek"
Date:
Subject: Using ora2pg Perl Script