Definitive answer: can functions use indexes?

From: Seamus Abshere <seamus(at)abshere(dot)net>
To: "" <pgsql-general(at)postgresql(dot)org>
Subject: Definitive answer: can functions use indexes?
Date: 2016-01-06 23:15:23
Message-ID: 1452122123.2259682.484964250.0BC5DCA2@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,

I've been using Postgres for years ( :heart: ) and I'm still in doubt
about this. Would somebody provide an authoritative, definitive,
narrative answer?

-> Can a function like `LEFT()` use an index?

(Or do I have to find an "equivalent" operator in order to leverage
indexes?)

Thanks!
Seamus

--
Seamus Abshere, SCEA
+598 99 54 99 54
https://github.com/seamusabshere

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2016-01-06 23:35:06 Re: Definitive answer: can functions use indexes?
Previous Message John R Pierce 2016-01-06 22:54:41 Re: Submitting to this list