On Saturday 23. May 2009, Stefan Keller wrote: >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.
The «best practice» here is probably rethinking your design. Storing an «unforeseeable number of key/value pairs in a column» is a blatant violation of good database design principles. Rodrigo posted this link a few hours ago: http://joecelkothesqlapprentice.blogspot.com/2006/04/using-one-table-vs-many.html -- Leif Biberg Kristensen | Registered Linux User #338009 Me And My Database: http://solumslekt.org/blog/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
