Hi, You should read the first chapters of the Postgis documentation (http://postgis.org/documentation/manual-2.0/) : it introduces spatial data, spatial types and functions. Postgis is working on Geometry type, not on classic, "scalar" attributes.
Nicolas On 8 October 2012 14:40, tasneem dewaswala <tasneem.eur...@gmail.com> wrote: > Hello, > > I am developing an application to find whether two cars are in each other > communication range or not. > I have two tables like receiver and transmitter. i would like to know if > receiver is in 100 meters range of transmitter or not. > Since i am using PostgreSQL first time, i donno much about its functions and > commands, but i have found that there is ST_Within(), which can be used for > my work. I tried but it gives me lot of errors, probably because of data > types of my latitude and longitude. they are in two different columns with > datatype as double precision. > > please tell me what is wrong, and how should i use ST_WITHIN for my work. Or > tell me any other way of knowing if two objects are in range of each other. > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users