Greg,
I don't understand your idea ! Why do you need three Ltrees ?
Oleg
On Tue, 26 Oct 2004, Greg Saylor wrote:
Hello,
First let me thank Mike for his earlier suggestion that I consider using
ltree - it really is working very nicely!...
I do have a question about performance/design though...
I
Hello,
First let me thank Mike for his earlier suggestion that I consider using
ltree - it really is working very nicely!...
I do have a question about performance/design though...
I have a table like this:
CREATE TABLE sometable (
id SERIAL,
category0 LTREE,
category1 LTR
Somehow I missed the ltree[] array stuff - this solves fairly nicely at
least the second part of my problem, but I'm still not sure how to
optimize the query which contains the union...
My optimized table looks like this:
CREATE TABLE sometable (
id SERIAL,
category LTREE[]
);
