Skip site navigation (1) Skip section navigation (2)

Re: require some suggestion to write trigger function

From: jr <jorg(dot)raskowski(at)tailorware(dot)org(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: require some suggestion to write trigger function
Date: 2009-09-07 16:19:44
Message-ID: h839am$6ra$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)tailorware(dot)org(dot)uk)

In response to

pgsql-novice by date

Next:From: NathanielDate: 2009-09-08 09:48:48
Subject: Large datasets
Previous:From: Michael WoodDate: 2009-09-07 15:59:04
Subject: Re: problem loading sql to database?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group