Trigger problem 2

From: Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Trigger problem 2
Date: 2004-12-01 04:20:17
Message-ID: 41AD4681.2050409@doitonce.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Attachment Content-Type Size
jamie.vcf text/x-vcard 265 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message OpenMacNews 2004-12-01 04:36:52 Re: createlang fails w/ 'undef ref to
Previous Message Jan Wieck 2004-12-01 04:14:48 Re: Upcoming Changes to News Server ...