Re: [GENERAL] Search across multiple sources

2004-02-02 Thread Bernd Helmle
Merrall, Graeme wrote: I don't think there's an easy way to do this but I thought I better ask just in case. I'm trying to come up with a way to search across a number of databases without resorting to lots of horrible scripts. In one database I have a lot of news stories from our news provider wh

Re: [GENERAL] Search across multiple sources

2004-02-01 Thread Merrall, Graeme
> On Sun, 1 Feb 2004, Merrall, Graeme wrote: > > > > > I don't think there's an easy way to do this but I thought > I better ask just in case. I'm trying to come up with a way > to search across a number of databases without resorting to > lots of horrible scripts. In one database I have a lo

Re: [GENERAL] Search across multiple sources

2004-02-01 Thread Oleg Bartunov
Why not use schema and single search table contains indices from different schemes (use trigger to update search table) On Sun, 1 Feb 2004, Merrall, Graeme wrote: > > I don't think there's an easy way to do this but I thought I better ask just in > case. I'm trying to come up with a way to sear

[GENERAL] Search across multiple sources

2004-01-31 Thread Merrall, Graeme
I don't think there's an easy way to do this but I thought I better ask just in case. I'm trying to come up with a way to search across a number of databases without resorting to lots of horrible scripts. In one database I have a lot of news stories from our news provider while in another data