From owner-freebsd-database Mon Mar 30 12:24:10 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id MAA12356 for freebsd-database-outgoing; Mon, 30 Mar 1998 12:24:10 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from sendero.simon-shapiro.org (sendero-fddi.Simon-Shapiro.ORG [206.190.148.2]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id MAA12342 for ; Mon, 30 Mar 1998 12:24:05 -0800 (PST) (envelope-from shimon@simon-shapiro.org) Received: (qmail 3571 invoked from network); 30 Mar 1998 20:33:15 -0000 Received: from localhost.simon-shapiro.org (HELO sendero-fxp0.simon-shapiro.org) (@127.0.0.1) by localhost.simon-shapiro.org with SMTP; 30 Mar 1998 20:33:15 -0000 Message-ID: X-Mailer: XFMail 1.3-alpha-032398 [p0] on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: Date: Mon, 30 Mar 1998 12:33:15 -0800 (PST) Reply-To: shimon@simon-shapiro.org Organization: The Simon Shapiro Foundation From: Simon Shapiro To: Bob Bishop Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update Cc: Wolfram Schneider , freebsd-database@FreeBSD.ORG, andreas@klemm.gtn.com, scrappy@hub.org, (Satoshi Asami) , Amancio Hasty Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On 30-Mar-98 Bob Bishop wrote: > At 7:19 pm +0100 30/3/98, Simon Shapiro wrote: >>On 30-Mar-98 Bob Bishop wrote: >>>...free-text search too. >> >>Yup. This is in the head-scratching stage still. I was thinking of >>either >>glimpse or maybe simply extracting the blob and applying regex to it. >>Comments? > > Slooow. The best you can say is that they both (IIRC about glimpse) scale > linearly. You really need something dictionary-based. Somebody smart may want to build a new Postgres data type that does exactly that; Grab a text array, parse into words, sort into a dictionary, etc. Sounds like fun project. Should not take all year either. ---------- Sincerely Yours, Simon Shapiro Shimon@Simon-Shapiro.ORG Voice: 503.799.2313 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message