On Monday 23 Jun 2003 6:42 am, Anagha Joshi wrote: > Hi, > I'm new to postgres and using version 7.2.4 > > I've created a trigger and function which does the following: > trigger 'T' fires after insert on a spcific table takes place > and it executes function 'F' > > Function 'F' returns the new record inserted by 'return new' statement. > > Now my question is: > How can I use this 'new' value in my client program? In this prgm., I > want to know which all values are inserted into the table.
Short answer - you don't. I'm not sure why you want to do this - if you just inserted the new values, surely you know what they are? There was something very similar to this last week, I'd have a look in the mailing-list archives at http://archives.postgresql.org - it was either this list or "general". -- Richard Huxton ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
