Re: Index order - Mailing list pgsql-general

From Glyn Astill
Subject Re: Index order
Date
Msg-id 791333.3682.qm@web25807.mail.ukl.yahoo.com
Whole thread Raw
In response to Re: Index order  (Korry Douglas <korry.douglas@enterprisedb.com>)
List pgsql-general
> Write a function that strips out the characters you want to
> ignore
> (returning the rest of the given string) and then create an
> index on
> that function.
>

Hmm, thanks for the suggesgion. Although the problem seems to have been that the locale I was using was ignoring those
characterswhen they should have been taken into account, so taking them out wouldn't have helped. 

It's all academic now anyway, I dumped the databases on all the servers, re-initdb'd, reloaded the data and fudged
slonyback in. 




pgsql-general by date:

Previous
From: Martin Gainty
Date:
Subject: Re: Bad Timestamp Format at 23 in ...
Next
From: Naz
Date:
Subject: Re: 8.3.3 stability ?