Jeffery L Post <postjeff(at)uwm(dot)edu> writes:
> I am just wondering how I can select from a generated dataset.
Use 7.1.
> ex.
> Select * from (
> select first, last from staff where salary > 12000
> union
> select first, last from staff where salary < 50000
> )
> order by last
... although this example is not exactly compelling, since you could
just write
select first, last from staff where salary > 12000
union
select first, last from staff where salary < 50000
order by last
regards, tom lane