On Fri, Feb 24, 2006 at 09:02:04AM -0800, CG wrote: > I have a search table which I use for partial-match text searches: <snip> > For a string "Hello World" the ltree is created like 'h.e.l.l.o.w.o.r.l.d' ... > If I wanted to find all rows with "orl" in them i would construct an lquery > like '*.o.r.l.*' and use the "~" operator in the where clause. I would link to > the table "items" by the item_id ... Is there some reason you can't use tsearch2? I suspect it would probably work better; if nothing else you'd probably get better support since a lot more people use it. -- 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
