Home > mailing lists

Asssociative Arrays: Best practices / snippets? - Mailing list pgsql-general

From	Stefan Keller
Subject	Asssociative Arrays: Best practices / snippets?
Date	May 23, 2009 09:25:34
Msg-id	25bc040b0905230225t5151b29u859f01caeba95c34@mail.gmail.com Whole thread Raw
Responses	Re: Asssociative Arrays: Best practices / snippets? Re: Asssociative Arrays: Best practices / snippets? Re: Asssociative Arrays: Best practices / snippets?
List	pgsql-general

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.

From: Scott Marlowe
Date: 23 May 2009, 07:34:41
Subject: Re: Code tables, conditional foreign keys?

From: Alban Hertroys
Date: 23 May 2009, 09:37:56
Subject: Re: duplicate rows in query