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. ???
- [GENERAL] How to create an index using a function??? Philip Hallstrom
- Re: [GENERAL] Lock up on 7.0.2 involving CREATE FUN... Philip Hallstrom
- Re: [GENERAL] Lock up on 7.0.2 involving CREATE... Prasanth A. Kumar