Re: [GENERAL] Location Data

2011-06-20 Thread Christian Ullrich
* Adarsh Sharma wrote: Christian Ullrich wrote: Write a set of functions to get the higher-level structures (country for states, etc.) for any given record, and put a trigger on the table that populates the fields on insert and update. All the world data is populated in the places table

Re: [GENERAL] Location Data

2011-06-19 Thread Christian Ullrich
* Adarsh Sharma wrote: Today I am facing a simple problem that I fail to solve after 2 day try. I have a places table in database whose structure is as : CREATE TABLE places ( woe_id character varying(15) NOT NULL, iso character varying(6), "name" text, "language" character varying(6), place_t