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;
$$ LANGUAGE SQL;
DAQ
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
