February 5th, 2003, 06:14 PM
Ltree module for tree hierarchies
I've played around with the dmoz example and am now trying to import my own data. The difficulty is that ltree is being a bitch about datatypes...
UPDATE finmatrix_ltree SET finmatrix_path = '1' || finmatrix_id
ERROR: column "finmatrix_path" is of type ltree but expression is of type text
You will need to rewrite or cast the expression
But this works...
UPDATE finmatrix_ltree SET finmatrix_path = ('1.2')::ltree;
Anyone know how I can concat values to go into column of datatype ltree?
Last edited by ultraslacker; February 5th, 2003 at 06:52 PM.
February 6th, 2003, 10:20 AM
Setting output file then using COPY works.