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@xxxxxxxxx> 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@xxxxxxxxxxxxxx) > 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@xxxxxxxxx / Skype: gray-hemp -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
