Query question - Mailing list pgsql-general

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