| 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: | Whole Thread | Raw Message | 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
| 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? |