On Mon, Jul 2, 2012 at 6:59 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > 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?
Doh. You're right: I keep forgetting that arrays have to be rectangular. Any suggestions on a sensible way to represent this? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers