PostgreSQL 透视/行转列和oralce pivot

将每间卧室的平均价格显示为列，将街区显示为行？
---------------------------------------------
id    neighborhood    bedrooms    price
1     downtown        0           256888
2     downtown        1           334000
3     riverview       1           505000
etc.
--------------------------------------------
            0       1       2       3
riverton    250000  300000  350000  -
downtown    189000  325000  -       450000
----------------------------------------------
SELECT neighborhood, bedrooms, avg(price)
FROM   listings
GROUP  BY 1,2
ORDER  BY 1,2
--------------------------------------------
SELECT neighborhood,
       round(avg((CASE WHEN bedrooms = 0 THEN price END)), 2) AS "0",
       round(avg((CASE WHEN bedrooms = 1 THEN price END)), 2) AS "1",
       round(avg((CASE WHEN bedrooms = 2 THEN price END)), 2) AS "2",
       round(avg((CASE WHEN bedrooms = 3 THEN price END)), 2) AS "3"
FROM listings
GROUP BY nei