Re: Creating Functions & Triggers

Dear Kevin ,

>> CREATE FUNCTION email_mod_date() RETURNS TRIGGER 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.
>
>
> Thanks for the suggestion, unfortunately it still hangs when I try and
> update a record.
>
>> But why you need a trigger for all this.
>>
>> Just use a default value for the respective column's .
>
>
> Isn't the default value only used during the initial insert of a
> record?  How would I set the default value for an UPDATE only?

Yes, you can set the default value for update of a record
just with

UPDATE email SET  m_date = DEFAULT, m_by_user = DEFAULT  WHERE id = some_id;

I am doing this thing in  PostgreSQL 7.4.2

>
> Sorry for the basic questions, but I'm quite new to this.

Its ok, read above
Kindly pas on the query you are issuing .

--
Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Jabber IM: vishalkashyap@jabber.org
ICQ :      264360076
Yahoo  IM: mailforvishal@yahoo.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---------------------