Re: Case insensitive selects?

From: David Wheeler <david(at)wheeler(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Case insensitive selects?
Date: 2001-02-15 23:17:00
Message-ID: Pine.LNX.4.21.0102151515210.17559-100000@theory
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Wheeler 2001-02-15 23:28:47 Re: Case insensitive selects?
Previous Message Alfonso Peniche 2001-02-15 22:04:46 aliases for temp tables....