plpgsql how to iterate through record values?

From: "german pulido" <german_pulido(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: plpgsql how to iterate through record values?
Date: 2002-03-20 15:26:30
Message-ID: a7a9b8$q9e$1@jupiter.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Eckermann 2002-03-20 15:57:54 Re: How to create crude report with psql and/or plpgsql
Previous Message Stephan Szabo 2002-03-20 04:08:39 Re: What is Syntax for multiple FULL OUTER JOINS?