Philip Hallstrom <[EMAIL PROTECTED]> writes:
> Hi -
> The following statements lock up my machine completely (I can
> ping, but can't telnet, nothing). This is FreeBSD 3.4-STABLE running
> 7.0.2.
>
> rolo_entry.fname is of type VARCHAR(30).
>
> devloki=> CREATE FUNCTION upper(VARCHAR) RETURNS TEXT AS '
> devloki'> BEGIN
> devloki'> RETURN UPPER($1);
> devloki'> END;
> devloki'> ' LANGUAGE 'plpgsql';
> CREATE
> devloki=> CREATE INDEX foo_idx ON rolo_entry (upper(fname));
>
> If I rename the function to say "am_upper" it works just fine.
>
> ???
I'm guessing that since sql is case insensitive, that results in
infinite recursion because you have a function upper() which calls
UPPER().
--
Prasanth Kumar
[EMAIL PROTECTED]
