Re: Searching a gin index - Mailing list pgsql-general

From Oleg Bartunov
Subject Re: Searching a gin index
Date
Msg-id Pine.LNX.4.64.0902061844250.4158@sn.sai.msu.ru
Whole thread Raw
In response to Re: Searching a gin index  (James Dooley <jamdooley@gmail.com>)
List pgsql-general
On Fri, 6 Feb 2009, James Dooley wrote:

> Richard, I was refereing to the plainto_tsquery
>
> Oleg, I only need colasque if any of those columns can be null, which is not
> the case here. Correct?

yes, but for safety and generality I'd use coalesce.


     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

pgsql-general by date:

Previous
From: James Dooley
Date:
Subject: Re: Searching a gin index
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: v8.2.12 released?