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.