Обсуждение: Aliasing on tables ...

Is there any possibility to access a column using the alias for the
column in the where clause?
Queries like that don't seem to work:

SELECT name || ' bought ' || amount || ' units' AS result FROM sales
where
result='abc';
ERROR:  Attribute 'result' not found


That works perfectly well:
SELECT name || ' bought ' || amount || ' units' AS result FROM sales
where
name || ' bought ' || amount || ' units'='abc';

result
--------
(0 rows)


Is there any possibility to do this with PostgreSQL 7.0.3?
   Hans