#1
  1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2002
    Posts
    56
    Rep Power
    12

    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 05:52 PM.
    Casuistry Agnostic
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2002
    Posts
    56
    Rep Power
    12
    Setting output file then using COPY works.
    Casuistry Agnostic

IMN logo majestic logo threadwatch logo seochat tools logo