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