Re: [GENERAL] GiST index question

2014-09-04 Thread Eric Fleming
Thank you both, I will look into alternative data types. I don’t think ltree will work for my purposes but I am going to try out some others that might; like cube. — Eric Fleming On Thu, Sep 4, 2014 at 3:42 AM, Giuseppe Broccolo wrote: > Hi Eric, > As Michael said, path data type does not supp

Re: [GENERAL] GiST index question

2014-09-04 Thread Giuseppe Broccolo
Hi Eric, As Michael said, path data type does not support for gist operators. Anyway, you could redefine data type using 'ltree' instead of 'path'. Take a look on the following link: http://www.postgresql.org/docs/9.1/static/ltree.html Try to understand if this could be fine for you. Cheers, G

Re: [GENERAL] GiST index question

2014-09-03 Thread Michael Paquier
On Thu, Sep 4, 2014 at 8:35 AM, Eric Fleming wrote: > I have a table that I have defined as: > > CREATE TABLE test ( > "id" SERIAL PRIMARY KEY, > "first_path" path NOT NULL, > "second_path" path NOT NULL > ); > > I am attempting to create a GiST index on the two "path" columns using: > > CREATE IN