Re: [GENERAL] Case insensitive selects?

[David Wheeler]

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