how to key/value iterate in stored function - Mailing list pgsql-general

From J.V.
Subject how to key/value iterate in stored function
Date
Msg-id 4E959A3D.3010001@gmail.com
Whole thread Raw
Responses Re: how to key/value iterate in stored function  (Chris Travers <chris.travers@gmail.com>)
Re: how to key/value iterate in stored function  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
I want to create a variable that is an array or list of key/value pairs.

The key would be a table name and the value would be a sql statement or
a value or list of values for which I could extract to create a sql
statement and execute.

I have tried experimenting with various arrays, but there is no clear
example or documentation.  The key and the value would be text.

I want to iterate over the entire array (or list), so would need an
example on that or some pointers there, if there is help.


J.V.


pgsql-general by date:

Previous
From: Sarma Chavali
Date:
Subject: Conceptual Architecture
Next
From: Chris Travers
Date:
Subject: Re: how to key/value iterate in stored function