| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Jae-Woong Hwnag <jaewh(at)email(dot)com> |
| Cc: | "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Union on view and.. |
| Date: | 2001-03-15 05:09:52 |
| Message-ID: | Pine.BSF.4.21.0103142106490.8324-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
If you're willing to wait or use the betas, 7.1
should probably do both of these. (Won't
quite make toast though).
[Although I believe the second'll be something
like: select * from (select * from table) alias;]
On Wed, 14 Mar 2001, Jae-Woong Hwnag wrote:
> Hi, all,
>
> Could somebody tell me if there is a work around to
> create "union on view" (which seems not implemented
> in the postgres yet) ?
>
> Also, is there any alternative query that can do:
>
> select * from (select * from table);
>
> I could not find an answer from the old archieve,
> and sorry if this has been answered previously.
> (I am new here :)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Allen | 2001-03-15 08:52:13 | Database corruption in 7.0.3 |
| Previous Message | Jae-Woong Hwnag | 2001-03-15 04:53:02 | Union on view and.. |