Asssociative Arrays: Best practices / snippets?

[Stefan Keller <sfkeller@xxxxxxxxx>]

I have a use case where the I want to put an unforeseable number of key/value pairs in a column.

Now, PostgreSQL has arrays as first class types.

Are there any best practices and snippets (preferrably in plpgsql) for handling key/value pairs?

-- S.