| From: | Werachart Jantarataeme <it072560(at)it(dot)kmutt(dot)ac(dot)th> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | How can I use UNION in VIEW/RULE? |
| Date: | 1999-05-10 08:51:16 |
| Message-ID: | Pine.GSO.3.93.990510155037.19591B-100000@pegasus1 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I have 2 table say c1,c2 (same attributes) and then I would like to
CREATE VIEW c AS
SELECT * FROM c1
UNION
SELECT * FROM c2;
But the system not accept. (not implement)
Then I change to use
CRATE TABLE c (<** attributes are same as c1,c2 **>)
CREATE RULE r1 AS ON SELECT to c
DO INSTEAD
SELECT * FROM c2
UNION
SELECT * FROM c1;
Tbe system accept this rule but when I process 'SELECT * FROM c1;', the
result is not sastified; only tuples on c2 are display.
Is there other way to get result like above. One I've thought in mind is:-
CREATE RULE r1 AS ON SELECT to c
DO INSTEAD
SELECT funct_UNION(c1,c2);
But I have no idea how to do kinds of the function that return set of
tuple
WChart.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ZEUGSWETTER Andreas IZ5 | 1999-05-10 09:46:48 | Re: [HACKERS] Re: Number of parameters in a sql function |
| Previous Message | Werachart Jantarataeme | 1999-05-10 08:50:25 | Can a function return tuples |