| From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
|---|---|
| To: | James Dooley <jamdooley(at)gmail(dot)com> |
| Cc: | Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Searching a gin index |
| Date: | 2009-02-06 15:44:47 |
| Message-ID: | Pine.LNX.4.64.0902061844250.4158@sn.sai.msu.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devrim GÜNDÜZ | 2009-02-06 16:35:46 | Re: v8.2.12 released? |
| Previous Message | James Dooley | 2009-02-06 15:36:47 | Re: Searching a gin index |