Mime-Version: 1.0 (Apple Message framework v752.3)
Content-Transfer-Encoding: quoted-printable
Message-Id: <CD8629AA-978A-4DC0-946F-5AF3451CADC1@myemma.com>
Content-Type: text/plain; charset=ISO-8859-1; delsp=yes; format=flowed
To: pgsql-sql <pgsql-sql@postgresql.org>
From: Erik Jones <erik@myemma.com>
Subject: Rule rewrite to possible union?
Date: Thu, 6 Dec 2007 16:03:22 -0600

Here's what I'd like to happen, but I'm not seeing how it can be done.

Say we have this simple table:

CREATE TABLE foo (
id integer,
foo varchar
);

and then many tables along these lines:

CREATE TABLE ud1_foo (LIKE foo);
CREATE TABLE ud2_foo (LIKE foo);

What I'd like is to do is select against foo and if there is an id in =20=

the where clause equal to 1 or 2 add a union with the appropriate =20
table.  I could easily do this at the application level, but this is =20
for a migration (the ud tables are going away) and I'd like to =20
minimize the number of transient application code changes wherever =20
possible.  Is there any way I can make this happen?

Erik Jones

Software Developer | Emma=AE
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com