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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
