MUSA-620-Spring-2017/MUSA-620-Week-6

ERROR: Schema 'ST' does not exist

Closed this issue · 1 comments

When I try to run the second query with ST.Distance in my SELECT DISTINCT ON statement, I get an error saying schema ST does not exist. This is the code that I am trying to run -

SELECT DISTINCT ON (philly_accidents.id) philly_accidents.latitude, philly_accidents.longitud, streets.id, ST.Distance(philly_accidents.geom, streets.geom) as distance

FROM philly_accidents, streets

ORDER BY philly_accidents.id, ST.Distance (philly_accidents.geom, streets.geom)

Thanks for the help!

Okay I solved it! I used periods instead of underscores :)