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