Advertisement
Guest User

Untitled

a guest
Apr 17th, 2014
41
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. SELECT * FROM geo_name_cities
  2. WHERE ST_DWithin(lonlat, ST_Geomfromtext('POINT(11.75292 47.42321)', 1000))
  3. ORDER BY ST_Distance(lonlat, ST_Geomfromtext('POINT(11.75292 47.42321)',1000))
  4. limit 5;
  5.  
  6. ERROR: function st_geomfromtext(unknown, integer) does not exist
  7. SQL state: 42883
  8. Hint: No function matches the given name and argument types. You might need to add
  9. explicit type casts.
  10. Character: 57
  11.  
  12. ST_GeomFromText('POINT(-71.064544 42.28787)');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement