Function is a group of SQL statements that form a logical
unit and perform a particular task. Functions are used to
encapsulate a set of operations or queries to execute on a
database server.
For more information: http://www.postgresql.org/docs/8.0/interactive/typeconv-func.html
Create a function
To create a function:
- Click the
Function button in the main window
- Press the
New Function button
- Enter function properties on the appropriate tabs and
edit boxes
You can create a function using a valid Create Function sql
statement in the SQL tab
Design an existing function
To design a function:
- Select the function you want to design
- Click the
Design Function button
- Edit function properties on the appropriate tabs and edit
boxes
You can change the Security or Comment property of the procedure/function.
Delete a function
- To delete a function
- Select the function you want to delete
- Click the
Delete Function button
- Confirm deleting in the dialog window
|