On Tue, 29 May 2001, Tom Lane wrote:
> Gavin Sherry <[EMAIL PROTECTED]> writes:
> > The column 'zip' is of type text. As such, indices will not be used except
> > in the case when the where clause is WHERE zip ~ '^' for btree
> > indices.
>
> Uh ... nonsense.
Oh good, I was worried there for a s
Marc,
The column 'zip' is of type text. As such, indices will not be used except
in the case when the where clause is WHERE zip ~ '^' for btree
indices.
Gavin
On Tue, 29 May 2001, Marc G. Fournier wrote:
>
> Okay, just bit the bullet, upgraded to v7.1.2, and the problem still
> persists:
>
>