"PEDRO LOPEZ" <[EMAIL PROTECTED]> writes: > after struggling with 'function not defined errors', and unable to see what > was wrong I redefined the function as:
> CREATE OR REPLACE FUNCTION currentstatus_dtrig() RETURNS opaque AS > ... > and got the message to the effect of 'redefining return type as trigger', Yup. > This is strange, AFAICT I followed the documentation setting up the trigger > and functions (correct parameter signature and return type). It's been a long time (at least since 7.3) since the documentation recommended using OPAQUE for anything. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly