Re: Event Triggers reduced, v1 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Event Triggers reduced, v1
Date
Msg-id 4722.1341269978@sss.pgh.pa.us
Whole thread Raw
In response to Re: Event Triggers reduced, v1  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Event Triggers reduced, v1  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Patch: add conversion from pg_wchar to multibyte
Next
From: Tom Lane
Date:
Subject: Re: Event Triggers reduced, v1