Hi
Finally getting this trigger ro work have one last problem, im trying to use Trigger variables
sample code
UPDATE wip.resource set "name" = datarecord.borname where wip.resource."primary" = OLD."primary";
get the following error
Error: record "old" is not yet assigned
would be greatful for any help thx
begin:vcard fn:Jamie Deppeler n:Deppeler;Jamie org:Once;Development adr:;;46 Roseneath Street;North Geelong;Vic;3215;Australia email;internet:[EMAIL PROTECTED] title:Database Admin tel;work:+61 3 52278 6699 url:http://www.doitonce.net.au version:2.1 end:vcard
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org