Re: Mnogosearch (Was: Re: website doc search is ... )

On Sat, 3 Jan 2004, Oleg Bartunov wrote:

> > So, there are 15333 URLs that contain that word ... now, what I want to
> > find out is how many of those 15333 URLs contain
> > 'http://archives.postgresql.org/%%', which is 13415 ...
>
> what's the need for such query ? Are you trying to restrict search to
> archives ? Why not just have site attribute for document and use simple
> join ?

The searches are designed so that you can do sub-section searches ... ie.
if you only wanted to search hackers, the LIKE would be:

'http://archives.postgresql.org/pgsql-hackers/%%'

while:

'http://archives.postgresql.org/%%'

would give you a search of *all* the mailing lists ...

In theory, you could go smaller and search on:

'http://archives.postgresql.org/pgsql-hackers/2003-11/%% for all messages
in November of 2003 ...


----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664