* 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
* 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