Search Postgresql Archives

create operator class problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I wanted to play with ltree, but I'm having trouble running ltree.sql.
Everything in ltree.sql seems to work, except for the CREATE OPERATOR
CLASS statements, which error out like:

ERROR:  syntax error at or near "OPERATOR10"
LINE 3: OPERATOR10<@ (_ltree, ltree)RECHECK ,

...which is generated from:

CREATE OPERATOR CLASS gist__ltree_ops
    DEFAULT FOR TYPE _ltree USING gist AS
    OPERATOR    10  <@ (_ltree, ltree)  RECHECK ,
    OPERATOR    11  @> (ltree, _ltree)  RECHECK ,
    OPERATOR    12  ~ (_ltree, lquery)  RECHECK ,
    OPERATOR    13  ~ (lquery, _ltree)  RECHECK ,
    OPERATOR    14  @ (_ltree, ltxtquery)   RECHECK ,
    OPERATOR    15  @ (ltxtquery, _ltree)   RECHECK ,
    OPERATOR    16  ? (_ltree, _lquery) RECHECK ,
    OPERATOR    17  ? (_lquery, _ltree) RECHECK ,
    FUNCTION    1   _ltree_consistent (internal, internal, int2),
    FUNCTION    2   _ltree_union (internal, internal),
    FUNCTION    3   _ltree_compress (internal),
    FUNCTION    4   ltree_decompress (internal),
    FUNCTION    5   _ltree_penalty (internal, internal, internal),
    FUNCTION    6   _ltree_picksplit (internal, internal),
    FUNCTION    7   _ltree_same (internal, internal, internal),
    STORAGE     ltree_gist;

I'm running PostgreSQL 8.2.1.

I also gave the 'seg' contrib module a whirl, and it also errors out on
the CREATE OPERATOR CLASS statement.

-- 
Ron Peterson
https://www.yellowbank.com/


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux