Re: Case insensitive selects? - Mailing list pgsql-general

From David Wheeler
Subject Re: Case insensitive selects?
Date
Msg-id Pine.LNX.4.21.0102151528200.17559-100000@theory
Whole thread Raw
In response to Re: Case insensitive selects?  (David Wheeler <david@wheeler.net>)
List pgsql-general
Forgot to mention, I'm using 7.03.

Thanks,

David

On Thu, 15 Feb 2001, David Wheeler wrote:

> Hmmm... I'm trying to create an index,
>
> CREATE INDEX idx_server__host_name ON server(LOWER(host_name));
>
> But it won't create. Here's the error:
>
> ERROR:  DefineIndex: function 'upper(varchar)' does not exist
>
> Anyone know what's up with that? The table does have the host_name column
> of type VARCHAR.
>
> Thanks,
>
> David


pgsql-general by date:

Previous
From: David Wheeler
Date:
Subject: Re: Case insensitive selects?
Next
From: "Mark Cowlishaw"
Date:
Subject: Re: Fwd: Stalled post to pgsql-general