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