|
Hi, I am new to Postgres and am trying to write a query like the
one below (without any luck) SELECT col_speed, col_time, (col_speed / col_time) AS
distance FROM speed_ratings HAVING distance > ? ORDER BY distance In other words, I want to filter on a calculated column. But
I get an error that column distance is not defined column "distance" does not exist at
character 272 Interestingly if I remove the filter (HAVING distance > ?),
the query works. So I can sort on distance but not filter. I have tried substituting the HAVING clause with a WHERE
clause as well with no luck. I have also added a GROUP BY clause with the HAVING as well
with no luck. Any ideas? Thanks Sid |
