How to use an alias name in the current select

From: Guy Deleeuw <G(dot)De_Leeuw(at)eurofer(dot)be>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to use an alias name in the current select
Date: 2010-03-24 16:42:10
Message-ID: 4BAA40E2.3000805@eurofer.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello

I have :
SELECT
t_orders_articles.k_id AS k_id
,t_orders_articles.quantity AS order_qty
,(SELECT sum(quantity) FROM t_deliveries_articles WHERE
article_id = t_orders_articles.k_id) AS delivery_qty
, (t_orders_articles.quantity - delivery_qty) AS qty
FROM t_orders_articles
......;

But it's not working I receive the error :
ERROR : The column delivery_qty does not exist.

How can I make that without having 2 select call ?

Regards
Guy

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ray Stell 2010-03-24 17:10:31 8.2.15 pitr/00000001.history
Previous Message Alvaro Herrera 2010-03-24 03:22:57 Re: tuning auto vacuum for highly active tables