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
>