Just so that I don’t loose this, here are some interesting links on SQL functions for different databases:

TSQL Functions

PSOUG Library – aka Morgan’s Library

PostgreSQL Wiki: Code Snippets

PL/PgSQL Snippets