Robert Haas <robertmh...@gmail.com> writes: > So let's try to hammer something out now. The obvious thing that > occurs to me is to have a column in the catalog that is a 2-D array of > text, with the first element of each array being something like "tag" > or "subtag" (i.e. event_trigger_variable) and the remaining array > elements being a list of legal values. That is:
> WHEN thingy IN thingy IN ('item1', 'item2') AND otherthingy IN ('foo', 'bar') > would be represented as this array: > {{thingy,item1,item2},{otherthingy,foo,bar}} Um, doesn't that require nonrectangular arrays? Or is there some non-obvious reason why the lists of legal values will always be all the same length? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers