UPDATE wip.resource set "name" = datarecord.borname where wip.resource."primary" = OLD."primary";
get the following error
Error: record "old" is not yet assigned
If called from an INSERT then OLD is undefined, since there is no old version of the row.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]