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

Reply via email to