Database Reference
In-Depth Information
Earth.Africa.Nigeria
Earth.Africa.Angola
If you want to view countries in Europe use the following query:
SELECT path FROM countries WHERE path ~ 'Earth.Europe.*{1}';
path
---------------------
Earth.Europe.France
If you want to view countries in Asia use the following query:
SELECT path FROM countries WHERE path ~ 'Earth.Asia.*{1}';
path
------------------
Earth.Asia.Japan
Earth.Asia.China
This extension can be used in many situations, and has many functions for searching. You
can find more information in its documentation at http://www.postgresql.org/docs/current/
static/ltree.html .
Search WWH ::




Custom Search