Re: [GENERAL] Text search with multiple tables

2008-05-01 Thread Mont Rothstein
ector(...) @@ to_tsquery(...)) Is there a better way to do this? Thanks, -Mont On Thu, May 1, 2008 at 8:48 AM, Mont Rothstein <[EMAIL PROTECTED]> wrote: > Is it possible to perform a text search with tables A-->>B returning A for > matches in B? > What I want to do is to be able take col

[GENERAL] Text search with multiple tables

2008-05-01 Thread Mont Rothstein
Is it possible to perform a text search with tables A-->>B returning A for matches in B? What I want to do is to be able take columns from both A and B and perform a search based on the keywords entered by the user that matches A, B, or both but always returns A. Can this be done? Thanks, -Mont

Re: [GENERAL] Trouble with text search select statement

2008-04-30 Thread Mont Rothstein
Thank you. I knew it had to be something simple. Much appreciated. -Mont

[GENERAL] Trouble with text search select statement

2008-04-30 Thread Mont Rothstein
I am having trouble getting a multiple column text search select statement to work. I've setup the following: CREATE TABLE tstest (col1 text, col2 text); INSERT INTO tstest (col1, col2) VALUES ('bird', 'moon'); CREATE INDEX tstest_ts_idx ON tstest USING gin(to_tsvector('english', coalesce(col1, '

Re: [GENERAL] Postgres on 64bit Windows Server with WOW64

2006-08-01 Thread Mont Rothstein
it everywhere else.>> Does mingw support 64bit?>> Joshua D. Drake>>> >> > -Mont> > > >> >> > On 7/31/06, Joshua D. Drake <[EMAIL PROTECTED]> [EMAIL PROTECTED] >> wrote:> >>> >>

Re: [GENERAL] Postgres on 64bit Windows Server with WOW64

2006-07-31 Thread Mont Rothstein
e able to compile PostgreSQL to 64bit windows. Wesupport 64bit everywhere else.Does mingw support 64bit?Joshua D. Drake >> -Mont>>>> On 7/31/06, Joshua D. Drake <[EMAIL PROTECTED]> wrote:>>>> Mont Rothstein wrote:>> > Does anyone have experience with runni

Re: [GENERAL] Postgres on 64bit Windows Server with WOW64

2006-07-31 Thread Mont Rothstein
I wouldn't know that one way or the other :-)I was referring to Windows on Windows 64.Enables 32bit apps to run on 64bit Windows OSs, in case anyone wasn't familiar with it (I wasn't until today). -MontOn 7/31/06, Joshua D. Drake <[EMAIL PROTECTED]> wrote: Mont Rothstein wro

[GENERAL] Postgres on 64bit Windows Server with WOW64

2006-07-31 Thread Mont Rothstein
Does anyone have experience with running Postgres on Windows Server 2003 64bit using WOW64?In theory it *should* work, but it is always nice to hear from someone that has already taken the plunge :-)Thanks, -Mont