Tag: double

PostgreSQL Can’t Convert String to double precision

So I’m asked to do this query for a college project: SELECT l.city AS name, AVG((pr.ap_price::double precision * 7 – pr.weekly::double precision) …