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