how to list or array of key value pairs
I need to rephrase this because of some confusion as to what I was
looking for.
I want to create and initialize a list or array of key/value pairs.
Then I want to iterate through this list (or array) retrieving each
key/value for use in a sql statement.
I want to do this in a stored function.
that's all
any ideas?
J.V.
Probably this will help you
http://www.postgresql.org/docs/current/interactive/hstore.html
ps. Look at the each() function.
On 12 October 2011 22:45, J.V. <jvsrvcs@gmail.com> wrote:
I need to rephrase this because of some confusion as to what I was looking
for.I want to create and initialize a list or array of key/value pairs. Then I
want to iterate through this list (or array) retrieving each key/value for
use in a sql statement.I want to do this in a stored function.
that's all
any ideas?
J.V.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sergey Konoplev
Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray.ru@gmail.com / Skype: gray-hemp
Yes, I have seen this before.
But I need an array of key/value pairs (key is string, value is string)
and I need to iterate through the array accessing both the key and the
value.
I look at this page and it does not translate very well into what I need
to do. If there are any specific examples out there, it would be
greatly appreciated.
Sincerely,
J.V.
Show quoted text
On 10/13/2011 2:18 AM, Sergey Konoplev wrote:
Probably this will help you
http://www.postgresql.org/docs/current/interactive/hstore.htmlps. Look at the each() function.
On 12 October 2011 22:45, J.V.<jvsrvcs@gmail.com> wrote:
I need to rephrase this because of some confusion as to what I was looking
for.I want to create and initialize a list or array of key/value pairs. Then I
want to iterate through this list (or array) retrieving each key/value for
use in a sql statement.I want to do this in a stored function.
that's all
any ideas?
J.V.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Oct 14, 2011 at 3:22 PM, J.V. <jvsrvcs@gmail.com> wrote:
Yes, I have seen this before.
But I need an array of key/value pairs (key is string, value is string) and
I need to iterate through the array accessing both the key and the value.I look at this page and it does not translate very well into what I need to
do. If there are any specific examples out there, it would be greatly
appreciated.
you keep getting the same answer because as you described your problem
it does *exactly* what you want to do. so, either you are not
describing the problem well or you are not understanding us:
postgres=# select * from each('a=>1,b=>2');
key | value
-----+-------
a | 1
b | 2
(2 rows)
can be dropped directly into plgsql
for record_variable in select * from each('a=>1,b=>2')
loop
<do stuff>
end loop;
etc. What's the issue?
merlin