Re: Triggers: using table's primary key value to update another field

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Triggers: using table's primary key value to update another field
Date: 2005-03-31 13:57:04
Message-ID: d2gvli$16f7$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


"Randall Perry" <rgp(at)systame(dot)com> writes
> What I'm having trouble with is figuring out how to grab the primary key
> value of the current row. I tried tacking on a var with the pkey row name
to
> NEW, but that doesn't work (didn't think it would).

There is an example in PG docs.

http://www.postgresql.org/docs/8.0/static/trigger-example.html

Regards,
Qingqing

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Qingqing Zhou 2005-03-31 14:02:30 Re: Postgres Processing Help !!!!
Previous Message Qingqing Zhou 2005-03-31 13:51:16 Re: truncate/create slowness