ion in order to catch the
notice event?
Luca.
From: Kenneth Downs <[EMAIL PROTECTED]>
To: Luca Ciciriello <[EMAIL PROTECTED]>
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Retrieve the record ID
Date: Fri, 20 Jul 2007 08:49:33 -0400
We have a system that sends back
We have a system that sends back information by using the RAISE NOTICE.
I've taken two lines out of it and put them here to illustrate the
idea. You may have to play with it to get it right:
NotifyList = 'The OID is: ' || CAST(new.oid as varchar(10)) || ';';
RAISE NOTICE '%',NotifyList;
Luc
Luca Ciciriello wrote:
Hi all.
I'm new to this list and, first of all, I'm a new user of PostgreSQL.
The version I'm using is 8.2.3 and I've the necessity to retrieve, using an
application, the ID of a modified (INSERT, UPDATE, DELETE) record of a
triggered table. I wasn't able to find out a way