title: Return points present in circle of particular radius from specified location
body: <p>I'm using PostgreSQL. I wish to return the points withing circle from particular point that is geocode. Now i have a geocode and radius of circle. From this data can i calculate the points present within the circle?
   Actually i have tried this with PostGIS and it's working fine but PostGIS deals with spatial data only and i have non-spatial data. 
  In PostGIS i have used following query :</p>
  
  <pre><code>select addressid,ST_AsText(geocode)geocode from aspatial_address as A where ST_Point_Inside_Circle(a.geocode,14.083333,19.583333,7)
  </code></pre>
  
  <p>my table structure is :</p>
  
  <pre><code>create table maddress
  {
   addressid bigint(30) primary key;
   addressline varchar2(40) not null;
   geocode varchar2(20) not null;
  }
  </code></pre>
  
  <p>and i wish to return the points present in circle whose radius is 7 km from geocode(14.083333,19.583333).</p>
  
  <p>Now, hint me..how can i do this in PostgreSQL? Is it possible here? Is their any geometric function used in PostgreSQL? Please let me know..</p>