I'd like to do some calculation with values from the table, show them a
new column and use the values in a where-clause.
Something like this
select a, b , a*b as c from ta where c=2;
But postgresql complains, that column "c" does not exist.
Do I have to repeat the calculation (which might be even more complex
:-) ) in the "where"-clause, or is there a better way?
Thanks in advance.
pgsql-sql by date
|Next:||From: Andreas Kretschmer||Date: 2008-06-17 21:10:41|
|Subject: Re: using calculated column in where-clause|
|Previous:||From: TJ O'Donnell||Date: 2008-06-17 00:24:49|
|Subject: cool code_swarm animation of PostgreSQL development since 1996|