Re: How can I index a substring attribute?

From: Thiemo Kellner <thiemo(at)thiam(dot)ch>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: How can I index a substring attribute?
Date: 2003-08-14 05:20:31
Message-ID: 200308140720.31068.thiemo@thiam.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Am Donnerstag, 14. August 2003 01.22 schrieb Stephan Szabo:
> On Thu, 14 Aug 2003, Thiemo Kellner wrote:
> > I try to have an index that only contains substrings of an attribute.
> > (This is for a try of a port of a MySQL repository).
>
> For 7.3 and earlier, you'll need to wrap the substr in another function
> that takes just Name and passes the arguments because the functional
> indexes won't take the constant arguments.
>
> In 7.4 the indexes are more powerful and can do this directly (and many
> more things too).

So, if I understand right, I have to make my own function to wrap subst,
haven't I?

Thanks for advice.

Cheers,

Thiemo

--
root ist die Wurzel allen Übels

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message mathan 2003-08-14 06:10:45 Ho to test Miscellaneous Functions
Previous Message Cath Lawrence 2003-08-14 04:59:53 Large object - what's happening?