I tried hstore with no luck.
How do I initialize the array?
How do I loop through each key/value pair in a stored function to
retrieve the key and value for each item in the list?
I need a list of key value pairs. Any options there?
J.V.
On 10/12/2011 8:51 AM, Merlin Moncure wrote:
On Wed, Oct 12, 2011 at 8:46 AM, J.V.<jvsr...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
