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) AS Employees
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