error with Subquery

From: Max Bondaruk <maxim(dot)bondaruk(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: error with Subquery
Date: 2006-12-08 10:58:35
Message-ID: 1877909649.20061208135835@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

error with Subquery alias...

help...

SELECT *,(SELECT COUNT(id)
FROM articles a WHERE a.lft < articles.lft AND a.rgt > articles.rgt) AS depth
FROM articles
where (depth < 3)
ORDER BY lft

Max mailto:maxim(dot)bondaruk(at)gmail(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message DANTE Alexandra 2006-12-08 10:59:45 Questions about postgresql-8.2.0-2PGDG.src.rpm
Previous Message Martijn van Oosterhout 2006-12-08 10:51:15 Re: loading data, creating indexes, clustering, vacuum...