Skip site navigation (1) Skip section navigation (2)

Re: New PostgreSQL search resource

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: "'PostgreSQL General'" <pgsql-general(at)postgresql(dot)org>,Postgresql Advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: New PostgreSQL search resource
Date: 2004-01-19 20:27:13
Message-ID: Pine.LNX.4.33.0401191318550.11187-100000@css120.ihs.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-generalpgsql-www
On Mon, 19 Jan 2004, Joshua D. Drake wrote:

> Well, if you search for select distinct... OpenFTS automatically searches
> for select & distinct. My search returned:
> 
> 5 results with the first one being this:
> 
> http://www.commandprompt.com/community//search.lxp?lxpwrap=734/queries-select-lists.html
> 
> Which seems fairly accurate ;). Perhaps a better description of what the 
> problem actually is or
> the behavior you are expecting?

Yes, phrase searching generally means you enter an exact string of words, 
in a particular order, and it searches on those strings in that order.

this comes in handy when looking for strings where the words together mean 
one thing, and apart may mean something else, like

set transaction isolation level

Many of those words appear throughout the docs, and may well all appear on 
the same page but not be tied together with each other on each page.

If we do a phrase search we only see the places where those words are 
together.  Individual word searching gives me 11 results in htdig, whereas 
the phrase gives me 3 hits, the second of which is obviously the correct 
one (the first is release notes for 6.5...  hmmm.)  With the 11 results, 
moves it down to number 7.

This is especially useful when you can search on a couple of small phrases 
that might go together.  Anyway, it's no big deal, just wondering if it 
supported phrase searching.


In response to

pgsql-www by date

Next:From: Josh BerkusDate: 2004-01-19 20:33:45
Subject: Re: Bricolage: Impressive
Previous:From: Marc G. FournierDate: 2004-01-19 20:17:38
Subject: Re: Bricolage: Impressive

pgsql-advocacy by date

Next:From: Josh BerkusDate: 2004-01-19 20:30:53
Subject: Organizing the OSCON presence
Previous:From: Joshua D. DrakeDate: 2004-01-19 19:42:15
Subject: Re: New PostgreSQL search resource

pgsql-general by date

Next:From: Tom LaneDate: 2004-01-19 20:27:32
Subject: Re: Precedence of a TRIGGER vs. a CHECK on a column
Previous:From: Joshua D. DrakeDate: 2004-01-19 19:52:35
Subject: Re: Detecting database corruption

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group