Re: [GENERAL] citext like query and index usage

2009-09-22 Thread Tom Lane
Tore Halvorsen writes: > On Tue, Sep 22, 2009 at 8:49 PM, Alvaro Herrera > wrote: >> Tore Halvorsen escribió: >>> Is it possible to use an index for like queries on a citext column? >> Hmm, I think this needs one of the *_pattern_ops indexes.  I'm not sure >> if you can use the builtin ones with

Re: [GENERAL] citext like query and index usage

2009-09-22 Thread Tore Halvorsen
On Tue, Sep 22, 2009 at 8:49 PM, Alvaro Herrera wrote: > Tore Halvorsen escribió: >> Hi, >> >> Is it possible to use an index for like queries on a citext column? >> I'm using pg 8.4.1 on windows - with no changes to the default configuration. >> >> For example: >> >> CREATE TABLE test ( citext ci

Re: [GENERAL] citext like query and index usage

2009-09-22 Thread Alvaro Herrera
Tore Halvorsen escribió: > Hi, > > Is it possible to use an index for like queries on a citext column? > I'm using pg 8.4.1 on windows - with no changes to the default configuration. > > For example: > > CREATE TABLE test ( citext citext NOT NULL ); > INSERT INTO test select md5(random()::text)

Re: [GENERAL] citext like query and index usage

2009-09-22 Thread Emanuel Calvo Franco
> Is it possible to use an index for like queries on a citext column? > I'm using pg 8.4.1 on windows - with no changes to the default configuration. > > For example: > > CREATE TABLE test ( citext citext NOT NULL ); > INSERT INTO test select md5(random()::text) FROM generate_series(0, 100, >

[GENERAL] citext like query and index usage

2009-09-22 Thread Tore Halvorsen
Hi, Is it possible to use an index for like queries on a citext column? I'm using pg 8.4.1 on windows - with no changes to the default configuration. For example: CREATE TABLE test ( citext citext NOT NULL ); INSERT INTO test select md5(random()::text) FROM generate_series(0, 100, 1); CREATE