Postgres Pro
Downloads
Home   >   mailing lists

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

From David Wheeler
Subject Re: Case insensitive selects?
Date
Msg-id Pine.LNX.4.21.0102151515210.17559-100000@theory
Whole thread Raw
In response to Re: Case insensitive selects?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Case insensitive selects?
Re: Case insensitive selects?
List pgsql-general
Tree view 
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: Alfonso Peniche
Date:
Subject: aliases for temp tables....
Next
From: David Wheeler
Date:
Subject: Re: Case insensitive selects?