nested sub-select ?

Hi,

Anyone know if Postgresql can replicate this Oracle nested sub-select query 
(it uses the Oracle CURSOR operator)

SELECT deptname,      CURSOR (SELECT Empname, Sal             FROM emp             WHERE emp.deptno=department.deptno)
ASEmployees
 
FROM department
Where deptno=x


I want to output a nested list like this (ie. rows from the aliased 
employees table within their respective department)

Deptname: Sales         Employees-row-no: 1         Empname: Smith         Sal: 2000
         Employees-row-no: 2         Empname: Jones         Sal: 1000           ....


It would be very useful to have the ability to nest multiple CURSOR 
statements (or equivalent) within the SELECT clause.

Any help appreciated.

TIA

Chris Martin



________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com