On Wed, Feb 02, 2005 at 06:02:28PM +0800, Hasnul Fadhly bin Hasan wrote: > When new data is inserted, we have to use new.xxxx to access the data. > Is there another way to access the data that would be more generic > like value[1] and so on? This way, the tracker is independant of any > tables.
Procedural languages like PL/Perl, PL/Tcl, and PL/Python can access NEW and OLD columns without knowing the column names in advance. http://www.postgresql.org/docs/8.0/static/plperl-triggers.html http://www.postgresql.org/docs/8.0/static/pltcl-trigger.html http://www.postgresql.org/docs/8.0/static/plpython-trigger.html -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
