| From: | Michael Fork <mfork(at)toledolink(dot)com> |
|---|---|
| To: | David Wheeler <david(at)wheeler(dot)net> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Case insensitive selects? |
| Date: | 2001-02-16 20:11:32 |
| Message-ID: | Pine.BSI.4.21.0102161507530.26187-100000@glass.toledolink.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
This is the function Tom Lane told me to use in < 7.1 (IIRC, this will
cause problems in >= 7.1, so you have to remember to remove from your
dump)
CREATE FUNCTION "upper" (varchar ) RETURNS text AS 'upper' LANGUAGE
'INTERNAL';
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-02-16 20:14:22 | Re: Case insensitive selects? |
| Previous Message | Steve Wolfe | 2001-02-16 20:10:16 | Re: order of clauses |