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
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
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