complex views

[Thomas Reat]

I want to create a rule that transforms a query on one table to a query on
many with table names and columns named after one of the columns in the fake
table.

e.g.:

select a,b,c from foo where b='x.1' or b='y.1' or b='y.2';

to:

select a,'x.1',c from foo_x union
select a,'y.1',c from foo_y union
select a,'y.2',c from foo_y;

But it doesn't seem that I can manipulate the column data into table names
when I do it in a rule.

How can I do this?

[Thomas Reat]

tr*****@yahoo.c om (Thomas Reat) wrote in message news:<3c******* *************** ****@posting.go ogle.com>...

to:

oops, I mean:

select a,'x.1',c from foo_x where foo_x.a=foo.a and b='1' union
select a,'y.1',c from foo_y where foo_y.a=foo.a and b='1' union
select a,'y.2',c from foo_y where foo_y.a=foo.a and b='2';