Browse categories
PostgreSQL releases
- PostgreSQL 14 (dev)
- PostgreSQL 13 (latest)
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10
- PostgreSQL 9.6
- PostgreSQL 9.5
- PostgreSQL 9.4 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Progress reporting views
Contrib modules
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Categories
See also

CREATE FUNCTION

A DDL command for defining a function

CREATE FUNCTION is a DDL command for defining a function.

CREATE FUNCTION has always been present in PostgreSQL.

Change history

PostgreSQL 12
- option SUPPORT added (commit 1fb57af9)
PostgreSQL 9.6
- PARALLEL { UNSAFE | RESTRICTED | SAFE } option added (commit 7aea8e4f)
PostgreSQL 9.5
- TRANSFORM attribute added (commit cac76582)
PostgreSQL 8.4
- RETURNS TABLE syntax added (commit 69a785b8)
- WINDOW attribute added (commit 26ce4e85)
PostgreSQL 8.3
- options COST and ROWS added (commit 5a7471c3)
- CREATE FUNCTION ... SET syntax added (commit 2abae34a)
PostgreSQL 8.1
- support for IN/OUT/INOUT parameters (initial commit 47888fe8)
PostgreSQL 7.3
- syntax revised to match SQL99 standard (commit 94bdc485)

Note: any changes prior to PostgreSQL 7.3 are not reflected in this list.

References

PostgreSQL documentation: CREATE FUNCTION

Categories

See also

ALTER FUNCTION, DROP FUNCTION, CREATE PROCEDURE, check_function_bodies