Re: [GENERAL] Case insensitive selects?

[David Wheeler]

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