Skip site navigation (1) Skip section navigation (2)

Re: Rules, Select, Union

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Itai Zukerman <zukerman(at)math-hat(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Rules, Select, Union
Date: 2000-08-07 01:09:20
Message-ID: 3898.965610560@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
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

In response to

pgsql-sql by date

Next:From: Ang Chin HanDate: 2000-08-07 09:11:10
Subject: Functions too slow, even with iscachable?
Previous:From: Itai ZukermanDate: 2000-08-06 23:32:57
Subject: Rules, Select, Union

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group