Re: Query with rightmost function does not use index

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: - - <loh(dot)law(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Query with rightmost function does not use index
Date: 2011-08-08 04:39:46
Message-ID: CAFj8pRD8FgZ=NF4XsvWvnDWUt01yseEeHSSSi1dspchjQ0KJfA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

use a functional index

http://www.postgresql.org/docs/8.4/interactive/indexes-expressional.html

Regards

Pavel Stehule

2011/8/8 - - <loh(dot)law(at)hotmail(dot)com>:
> For a table where column col has an index, the query:
>      SELECT ... FROM ... WHERE col = MD5('')
> doesn't seem to use an index but
>      SELECT ... FROM ... WHERE col = 'd41d8cd98f00b204e9800998ecf8427e'
> does.
>
> Is this a gotcha?
> I'm using PostgreSQL 8.4.8 on i686-pc-linux-gnu, compiled by GCC
> gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2, 32-bit
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adarsh Sharma 2011-08-08 04:58:37 Granting Privileges in Postgres
Previous Message David Johnston 2011-08-08 03:50:02 Re: table / query as a prameter for PL/pgSQL function