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.

???

Reply via email to