Using record.items() method

From: Luís de Sousa <luis(dot)a(dot)de(dot)sousa(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Using record.items() method
Date: 2010-08-16 15:26:07
Message-ID: AANLkTikPGwpbzHVrZT-uTYz4HZvfOQ1p44c4CpJ6TtnS@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone,

I'm trying to code a function that processes records from various tables
performing the same action in each case. The functions receives as an
argument a RECORD type variable and I'd like to iterate through each of its
elements. According to the documentation here:

http://python.projects.postgresql.org/pldocs/plpython3-postgres-types-record.html

there exists an items() method that returns a set of tuples each with the
attribute name and the associated value. How can use this method with
pl/pgsql?

Thank you,

Luís

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Wild 2010-08-16 16:43:25 Re: Wrong "ORDER BY" on a numeric value result
Previous Message Eric Ndengang 2010-08-16 14:46:30 Re: How to refer to computed columns from other computed columns?