From: | "V i s h a l Kashyap (at) [Sai Hertz And Control Systems]" <sank89(at)sancharnet(dot)in> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Creating Functions & Triggers |
Date: | 2004-03-21 03:30:25 |
Message-ID: | 405D0C51.3040507@sancharnet.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Dear Kevin ,
> CREATE FUNCTION email_mod_date() RETURNS OPAQUE AS '
> BEGIN
> UPDATE email SET m_date = current_date, m_by_user = current_user
> WHERE id = NEW.id;
>
> RETURN NULL;
> END;
> 'LANGUAGE 'plpgsql';
CREATE FUNCTION email_mod_date() RETURNS OPAQUE AS '
DECLARE
BEGIN
UPDATE email SET m_date = current_date, m_by_user = current_user
WHERE id = NEW.id;
RETURN NEW;
END;
'LANGUAGE 'plpgsql';
This must do the job.
But why you need a trigger for all this.
Just use a default value for the respective column's .
--
Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Jabber IM: vishalkashyap(at)jabber(dot)org
ICQ : 264360076
Yahoo IM: mailforvishal(at)yahoo(dot)com
-----------------------------------------------
You yourself, as much as anybody in the entire
universe, deserve your love and affection.
- Buddha
---------------
pgsql=# select marital_status from vishals_life;
marital_status
------------------
Single not looking
1 Row(s) affected
___
//\\\
( 0_0 )
----------------o0o-----o0o---------------------
From | Date | Subject | |
---|---|---|---|
Next Message | V i s h a l Kashyap @ [Sai Hertz And Control Systems] | 2004-03-21 04:08:38 | Re: Creating Functions & Triggers |
Previous Message | Robert Morgan | 2004-03-21 01:01:03 | Re: connect from network PC |