Skip site navigation (1) Skip section navigation (2)

Re: index scan with functional indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pg(at)fastcrypt(dot)com
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: index scan with functional indexes
Date: 2004-01-27 18:48:15
Message-ID: 25856.1075229295@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Dave Cramer <pg(at)fastcrypt(dot)com> writes:
> I'm using 7.4.1, the db was initdb --locale='C'
> and no I don't get them on plain indexes ????

Oh?  If it's 7.4 then you can confirm the locale selection with
"show lc_collate" and "show lc_ctype" (I think the first of these
is what the LIKE optimization checks).

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Steve AtkinsDate: 2004-01-27 18:48:37
Subject: Re: Mixing threaded and non-threaded
Previous:From: Tom LaneDate: 2004-01-27 18:46:06
Subject: Re: Extending SET SESSION AUTHORIZATION

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group