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 :)