Re: Re: Re: MySQL has transactions - Mailing list pgsql-general

From Denis Perchine
Subject Re: Re: Re: MySQL has transactions
Date
Msg-id 01012419021604.00614@dyp.perchine.com
Whole thread Raw
In response to Re: Re: MySQL has transactions  (Alexander Jerusalem <ajeru@gmx.net>)
Responses Re: Re: Re: MySQL has transactions  (Alexander Jerusalem <ajeru@gmx.net>)
List pgsql-general
> * Fast case insensitive text search via indexes (function based indexes)

Try to:

create table test (s text);
create index ix_test_s on test(lower(s));

And try select * from test where lower(s) = 'test';

If you made vacuum, and have enough data in the table you will get index
scan. Also you will get index scan for this:
select * from test where lower(s) like 'test%';

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

pgsql-general by date:

Previous
From: Alexander Jerusalem
Date:
Subject: postgres memory management = Linux memory management
Next
From: The Hermit Hacker
Date:
Subject: RE: MySQL has transactions