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:28:47
Message-ID: Pine.LNX.4.21.0102151528200.17559-100000@theory
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mark Cowlishaw 2001-02-15 23:41:10 Re: Fwd: Stalled post to pgsql-general
Previous Message David Wheeler 2001-02-15 23:17:00 Re: Case insensitive selects?