Re: [GENERAL] sequential scans and the like operator (fwd)

[Roderick A. A. <raa...@ti...>]

My interest in the discussion of indexes grew so great I went to the
mountain (postgres mailing list) and asked.  Here is an exact answer
that agrees with the others I got.

Thanks Andrew,


Best,
Rod
-- 
---------- Forwarded message ----------
Date: Tue, 8 Jan 2002 13:45:55 -0500
From: Andrew Sullivan <an...@li...>
To: Roderick A. Anderson <raa...@ti...>
Subject: Re: [GENERAL] sequential scans and the like operator

On Tue, Jan 08, 2002 at 04:50:53AM -0800, Roderick A. Anderson wrote:

> My guesstimation is a leading or mid-field wildcard (_, %) would force a
> sequential scan but a trailing wildcard would not (should not?).

True, if you're not using a locale other than C.  If you are, you'll
get a seqscan no matter what.

A

-- 
----
Andrew Sullivan                               87 Mowat Avenue 
Liberty RMS                           Toronto, Ontario Canada
<an...@li...>                              M6K 3E3
                                         +1 416 646 3304 x110