> CREATE INDEX ie_cust_upper_name ON customer ( UPPER( customername ) )
> WHERE ( UPPER(customername) LIKE 'ABC%' );
ABC is different at every time.
This is first letters of customer name entered by user.
So I cannot add ABC to index.
Andrus.
---(end of broadcast)-
Hello
if you have non-c locale, you have to use varchar_pattern_ops - like:
create index like_index on lidi (prijmeni varchar_pattern_ops);
Regards
Pavel Stehule
On 18/02/2008, T.J. Adami <[EMAIL PROTECTED]> wrote:
> On 4 fev, 18:13, "Andrus" <[EMAIL PROTECTED]> wrote:
> > I need to perform cas
On 4 fev, 18:13, "Andrus" <[EMAIL PROTECTED]> wrote:
> I need to perform case insensitive search by first some characters (ABC) of
> name like
>
> SELECT ...
> FROM customer
> WHERE upper(customername) like 'ABC%'
>
> My database cluster locale is non-C
> Database encoding is UTF-8
>
> Which index