Received: from jupiter.hub.org (jupiter.hub.org [64.49.215.5]) by postgresql.org (Postfix) with ESMTP id B746F47606C for ; Wed, 20 Mar 2002 10:42:31 -0500 (EST) Received: (from news@localhost) by jupiter.hub.org (8.11.6/8.11.6) id g2KFKBj27334 for pgsql-sql@postgresql.org; Wed, 20 Mar 2002 09:20:11 -0600 (CST) (envelope-from news) From: "german pulido" X-Newsgroups: comp.databases.postgresql.sql Subject: plpgsql how to iterate through record values? Date: Wed, 20 Mar 2002 11:26:30 -0400 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 18 Message-ID: X-Complaints-To: news@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 To: pgsql-sql@postgresql.org X-Archive-Number: 200203/257 X-Sequence-Number: 7136 Im new to plpgsql... Does someone knows how to iterate through the values of a record in plpgsql? Im making a function that is dependent of the table configuration. I have many tables in the DB and would like to make only one function for all the triggers. To make it shorter, I would like a trigger that concatenates all the values of a new record when insert and update and stores it on a different table. Right now I know how to make a trigger for each table. Any help will be greatly appreciated. Thanks.