Functions

Functions are used mostly for calculations - they are usually scalar functions which return a single value.

Functions must have at least 1 input Parameter (usually more)

Typically they have a calculation defined using Expression Builder or SQL code to transform the input to the Output.

Design or Code View

Most requirements can be met using point & click design view - however for ultimate power and flexibility there is the option to switch to code view.

Power Users may actually prefer to use code view because SQL is such a concise powerful declarative functional language.

Anybuild offers the full power the Postgres SQL dialect - including hundreds of built in Functions and Operators plus many functions defined