From: | Alexander Jerusalem <ajeru(at)gmx(dot)net> |
---|---|
To: | Denis Perchine <dyp(at)perchine(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Re: Re: MySQL has transactions |
Date: | 2001-01-24 13:38:25 |
Message-ID: | 4.3.2.7.0.20010124143337.00bf4100@pop.gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Wow! postgresql is a miracle! :-)
I'm starting to wonder why anybody would want to use Oracle...
Alexander Jerusalem
ajeru(at)gmx(dot)net
vknn
At 14:02 24.01.01, Denis Perchine wrote:
> > * 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(at)perchine(dot)com
>HomePage: http://www.perchine.com/dyp/
>FidoNet: 2:5000/120.5
>----------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-01-24 13:44:16 | Re: [GENERAL] child table doesn't inherit PRIMARY KEY? |
Previous Message | Rob Arnold | 2001-01-24 13:32:33 | Re: VACUUM ANALYZE FAILS on 7.0.3 |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-01-24 13:39:44 | Libpq async issues |
Previous Message | Travis Bauer | 2001-01-24 13:23:26 | Re: GreatBridge RPMs (was: Re: question) |