Hey Ferruccio,
Also consider ltree contrib module as alternative.
http://www.postgresql.org/docs/9.0/static/ltree.html
;-)
2010/11/17 Ferruccio Zamuner nonsolos...@diff.org
MESH Data Tree:
example:
Hallux;A01.378.610.250.300.792.380
where:
A01 is Body Regions
A01.378 is Extremities
MESH Data Tree:
example:
Hallux;A01.378.610.250.300.792.380
where:
A01 is Body Regions
A01.378 is Extremities
A01.378.610 is Lower Extremity
A01.378.610.250 is Foot
A01.378.610.250.300 is Forefoot, Human
A01.378.610.250.300.792 is Toes
CREATE OR REPLACE FUNCTION mesh_split(text) RETURNS text[]
Στις Wednesday 17 November 2010 15:22:34 ο/η Ferruccio Zamuner έγραψε:
/* How to get access to its items then?
*/
select (mesh_split('A01.378.610.250.300.792.380')::text[])[1];
--
Achilleas Mantzios
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your