On Mon, Sep 19, 2005 at 07:23:54AM +0200, hubert depesz lubaczewski wrote: > On 9/18/05, Jim C. Nasby <jnasby@xxxxxxxxxxxxx> wrote: > > > > ltree is part of contrib, right? > > > > yes. > > You probably need to define a functional index of some kind. How are you > > querying now? IIRC you'll be doing something like region IN (ltree)? > > > > i didn't thought about functional indices, but this might be a solution. > have to think about it for a while > searching through ltree's is done using specific operators (>@). Yes, which is something I don't think the indexing code can deal with. IIRC you're looking for a way to index something that's in a specific place in the ltree, so you'd want to index that actual function expression. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
