From: | José María Terry Jiménez <jtj(at)tssystems(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | How to reference a subquery column alias? |
Date: | 2010-08-09 19:11:05 |
Message-ID: | 4C6052C9.7020405@tssystems.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
Yesterday a list user solved me a problem with a sententence with two
subqueries. The solution was this:
SELECT remota_id,min(hora),max(hora), (SELECT caudal FROM historicos
WHERE remota_id=ooo.remota_id AND hora=min(ooo.hora)) as min_caudal,
(SELECT caudal FROM historicos WHERE remota_id=ooo.remota_id AND
hora=max(ooo.hora)) as max_caudal from historicos AS ooo GROUP BY
remota_id ORDER BY remota_id;
The issue now is i want to do some calculations with the subqueries
columns (min_caudal and max_caudal), for example adding them. (Get a new
column with max_caudal and min_caudal (alias) added)
I have tried to add in the SELECT;
,max_caudal+min_caudal as diferencia
,ooo.max_caudal+ooo.min_caudal as diferencia
,historicos.max_caudal+historicos.min_caudal as diferencia
,(SELECT max_caudal+min_caudal) as diferencia
I've read the SELECT and Table Expressions documentation pages, but
didn't found a solution.
Can anyone tell me how to reference or make the calculation with those
alias names?
TIA
Best,
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Scanned with Copfilter Version 0.84beta3a (ProxSMTP 1.6)
AntiVirus: ClamAV 0.95.2/11523 - Mon Aug 9 19:20:40 2010
by Markus Madlener @ http://www.copfilter.org
From | Date | Subject | |
---|---|---|---|
Next Message | Hector Beyers | 2010-08-09 20:30:46 | Hector Beyers wants to stay in touch on LinkedIn |
Previous Message | Merlin Moncure | 2010-08-09 18:57:00 | Re: Is there a way to bypass sql? |