Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- proc qry(db: DbConn; lon, lat: float) =
- var
- arow = db.getRow(sql"""select hwy, fdfo, tdfo, geom from routes order by geom <-> ST_GeomFromText('POINT(? ?)', 4326) limit 1""", lon, lat)
- echo arow
- proc main() =
- let db = open("localhost", "grassy", "", "onsys")
- db.qry(-97.398444, 33.03654)
- db.close()
- grassy@localhost:~/www$ ./post
- db_postgres.nim(85) dbError
- Error: unhandled exception: ERROR: syntax error at or near "' '"
- LINE 1: ...der by geom <-> ST_GeomFromText('POINT('-97.398444' '33.0365...
- ^
- [DbError]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement