Re: Create trigger for auto update function - Mailing list pgsql-sql

Hello Andy,

Tuesday, July 19, 2005, 9:55:41 AM, you wrote:

>> CREATE FUNCTION update_pass() RETURNS integer AS $$
>>     UPDATE hoy SET pass_md5=md5(pass) WHERE id=new.id;
>>    SELECT 1;
>> $$ LANGUAGE SQL;
>>
>> CREATE TRIGGER triger_users_pass_md5
>>  AFTER INSERT OR UPDATE
>>  ON hoy FOR EACH ROW
>>     EXECUTE PROCEDURE update_pass;

A> I understand the ideea, but don't know how to apply it.
A> I also receive the error that NEW must be definde as a rule.

A> Still... not working...

Sorry! My fault. Trigger porcedure returns OPAQUE type.
CREATE FUNCTION update_pass() RETURNS OPAQUE AS $$    UPDATE hoy SET pass_md5=md5(pass) WHERE id=new.id;   SELECT 1;$$
LANGUAGESQL;
 


DAQ