Re: how to key/value iterate in stored function

On Wed, Oct 12, 2011 at 8:46 AM, J.V. <jvsrvcs@gmail.com> wrote:
> 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.

use thee the hstore!

postgres=# select * from each('a=>1,b=>2');
 key | value
-----+-------
 a   | 1
 b   | 2
(2 rows)

(if you do stick with arrays, use unnest() -- it can be built for
older versions if you don't have it).

merlin