Received: from web12705.mail.yahoo.com (web12705.mail.yahoo.com [216.136.173.242]) by postgresql.org (8.11.3/8.11.4) with SMTP id g0J4EAV28026 for ; Fri, 18 Jan 2002 23:14:10 -0500 (EST) (envelope-from chestercyoung@yahoo.com) Message-ID: <20020119041415.23759.qmail@web12705.mail.yahoo.com> Received: from [207.188.162.30] by web12705.mail.yahoo.com via HTTP; Fri, 18 Jan 2002 20:14:15 PST Date: Fri, 18 Jan 2002 20:14:15 -0800 (PST) From: chester c young Subject: oid in plpgsql trigger To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200201/230 X-Sequence-Number: 6314 Is there any way to get the current record's oid in a plpgsql trigger? In a before insert trigger the oid might not make any sense if the oid has not yet have been assigned, but it makes sense elsewhere. cc young "Beauty begets beauty, and ugly ugly." (paraphrase) Harry Truman __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/