Jeff, h012, > CREATE FUNCTION fn_strrev(text) returns text as ' > return reverse($_[0]) > ' language 'plperl' with (iscachable);
If you make that "WITH (ISCACHABLE, ISSTRICT)" the index will be faster to update on columns which contain large numbers of NULLs. "ISSTRICT" refers to the fact that if the function receives a NULL, it will output a NULL, and thus saves the parser the time running NULLs through the function. Also, remember to use this index, you'll have to call the exact same function in your queries. -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
