Re: Storing Pairs?

Charles Tassell <ctassell(at)isn(dot)net> writes:
> In a project I'm working on at the moment, I want to store multiple
> pieces of information about an item, and I'm looking for a good way to
> structure my tables. The items will have a variable number of descriptive
> attributes (ie, size, color, logo) so I was thinking of using arrays, but I
> don't think I can get the select options to work the way I want.

No, probably not --- and even if there were an "array search" kind of
operator, we don't have any indexes that would help. Use a variable
number of rows per entry, instead, with
item_name text
op_type int4
op_value int4
(or use an int4 key for the item, and store the name just once in a
different table...)

regards, tom lane