doing:
select t1*t2 as t, t*1 from (select target1,target2 from signals)
Gives:
column "t" does not exist
How can I refer to t at the same time I am declaring it in the select query?
Asked
Active
Viewed 67 times
1
Rodrigo Formighieri
- 455
- 7
- 18
-
2[PostgreSQL: using a calculated column in the same query](https://stackoverflow.com/questions/8840228/postgresql-using-a-calculated-column-in-the-same-query/36530228#36530228) – Lukasz Szozda Dec 26 '18 at 17:10
-
1@LukaszSzozda Oh nice, thank you so much – Rodrigo Formighieri Dec 26 '18 at 17:11
-
Possible duplicate of [PostgreSQL: using a calculated column in the same query](https://stackoverflow.com/questions/8840228/postgresql-using-a-calculated-column-in-the-same-query) – Lukasz Szozda Dec 26 '18 at 17:12
-
1Sure.. Thanks my friend – Rodrigo Formighieri Dec 26 '18 at 17:12
-
Are `t1` and `t2` referring to `target1` and `target2` respectively? – fixatd Dec 26 '18 at 19:31
-
@RodrigoFormighieri if you already got the answer you can answer it by yourself or delete this question.. – dwir182 Dec 27 '18 at 00:07