Select * from ( Select etc..) - Mailing list pgsql-general

Hello,
I am just wondering how I can select from a generated dataset.
ex.
  Select * from (
    select first, last from staff where salary > 12000
   union
    select first, last from staff where salary < 50000
   )
  order by last

I just took a class in oracle and I thought I remember doing just such a
thing. I know that Oracle does a lot of non-standard sql stuff but it
seems that this would be part of the standard.... I read through the to-do
list to see if it is somthing that is being worked on. But that just
stumped me....   What is this sort of thing called? selecting from a
generated dataset and is it somthing that is being worked on. Or is it
just somthing that I am making up in my head..


Thanks
    Jeff Post
University of Wisconsin - Milwaukee