Jamie Deppeler wrote:

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]

Reply via email to