Re: How can I index a substring attribute? - Mailing list 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