Postgres Pro
Downloads
Home   >   mailing lists

How to use an alias name in the current select - Mailing list pgsql-admin

From Guy Deleeuw
Subject How to use an alias name in the current select
Date
Msg-id 4BAA40E2.3000805@eurofer.be
Whole thread Raw
Responses Re: How to use an alias name in the current select  (Dimitri Fontaine <dfontaine@hi-media.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: blast
Date:
Subject: Re: Backup&Restore Postgres DB
Next
From: Ray Stell
Date:
Subject: 8.2.15 pitr/00000001.history