Itai Zukerman <zukerman(at)math-hat(dot)com> writes:
> CREATE RULE data_val AS
> ON SELECT TO data
> DO INSTEAD
> SELECT * FROM pos
> UNION
> SELECT * FROM neg;
IIRC, UNION doesn't work in rules at the moment (a fix is planned for
7.2). But what's the point of splitting the data into the two tables
like that? This example is far from compelling, so I wonder whether
you shouldn't be considering a schema redesign anyway ...
regards, tom lane