Re: [HACKERS] appendum: Re: *really* simple select doesn't useindices ...

2001-05-29 Thread The Hermit Hacker
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

Re: [HACKERS] appendum: Re: *really* simple select doesn't useindices ...

2001-05-29 Thread Gavin Sherry
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: > >