how to key/value iterate in stored function

From: "J(dot)V(dot)" <jvsrvcs(at)gmail(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: how to key/value iterate in stored function
Date: 2011-10-12 13:46:37
Message-ID: 4E959A3D.3010001@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2011-10-12 13:53:52 Re: how to key/value iterate in stored function
Previous Message Sarma Chavali 2011-10-12 11:08:50 Conceptual Architecture