Using record.items() method - Mailing list pgsql-general

From Luís de Sousa
Subject Using record.items() method
Date
Msg-id AANLkTikPGwpbzHVrZT-uTYz4HZvfOQ1p44c4CpJ6TtnS@mail.gmail.com
Whole thread Raw
List 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


pgsql-general by date:

Previous
From: Eric Ndengang
Date:
Subject: Re: How to refer to computed columns from other computed columns?
Next
From: Stefan Wild
Date:
Subject: Re: Wrong "ORDER BY" on a numeric value result