The list below is definitely not inclusive.
PostgreSQL allows you to create Custom User Functions. Seemed like a useful time saver, so we have includd this capability within Younicycle.
Younicycle (the web application) in the interests of Account security, imposes certain limits on Functions. Younicycle (The Server Package) does not impose those limits.
A few user functions will be added to Younicycle for all accounts & several 'sample' functions will be included within all accounts beginning in November 2008, such as the FV example below.
Create Custom Functions (SQL)
*To save screen space, 2 different functions are displayed. Immediately below 'type here' is set returning. FV is is displayed in yellow popup.
Younicycle also includes support for the creation of Triggers. Triggers and Functions are accessible by creating an appropriate Role, then assigning User(s). Note this should be considered an Advanced feature. Admins should provide availability only to 'Power Users'.
Custom User Functions are a Power Feature that allow you to accomplish complex tasks.
Once written - but reusable. A time saver for Experts.
Triggers are also written from this interface.
Read More