Postgres Pro
Downloads
Home   >   mailing lists

Query with rightmost function does not use index - Mailing list pgsql-general

From - -
Subject Query with rightmost function does not use index
Date
Msg-id BAY147-W60E0112B4451E58596D427F0210@phx.gbl
Whole thread Raw
Responses Re: Query with rightmost function does not use index
List pgsql-general
Tree view
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


pgsql-general by date:

Previous
From: Royce Ausburn
Date:
Subject: Effect of a kill -9 on postgres
Next
From: Craig Ringer
Date:
Subject: Re: Effect of a kill -9 on postgres