Re: [PERFORM] earthdistance query performance

2013-09-25 Thread Merlin Moncure
On Wed, Sep 25, 2013 at 10:05 AM, AI Rumman wrote: > Hi, > > I have a table with zip_code and latitude and longitude. > > \d zip_code_based_lng_lat > Table "public.zip_code_based_lng_lat" > Column | Type | Modifiers > ++--- > zip|

[PERFORM] earthdistance query performance

2013-09-25 Thread AI Rumman
Hi, I have a table with zip_code and latitude and longitude. \d zip_code_based_lng_lat Table "public.zip_code_based_lng_lat" Column | Type | Modifiers ++--- zip| character varying(100) | state | character varying(100) | city