Re: [GENERAL] Retrieve the record ID

2007-07-23 Thread Luca Ciciriello
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

Re: [GENERAL] Retrieve the record ID

2007-07-20 Thread Kenneth Downs
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

Re: [GENERAL] Retrieve the record ID

2007-07-20 Thread Shane Ambler
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