NAME CREATE_FUNCTION - define a new function SYNOPSIS CREATE [ OR REPLACE ] FUNCTION name ( [ [ argmode ] [ argname ... file ', ' link_symbol ' | sql_body } ... DESCRIPTION CREATE …null result is assumed automatically. See CREATE FUNCTION ( CREATE_FUNCTION (7)) for more information. IMMUTABLE ... function to the specified setting. See CREATE FUNCTION ( CREATE…register two or more functions (using CREATE FUNCTION ) before defining the type. The support functions ... compfoo AS (f1 int, f2 text); CREATE FUNCTION getfoo() RETURNS SETOF com…other SQL implementations. NOTES See CREATE FUNCTION ( CREATE_FUNCTION (7)) for more details on function ... many extensions. For details see also CREATE FUNCTION ( CREATE_FUNCTION…plpython3u; Then create the necessary functions: CREATE FUNCTION hstore_to_plpython(val internal) RETURNS internal ... LANGUAGE C STRICT IMMUTABLE AS ...; CREATE FUNCTION plpython_…overloading of ordinary function names (see CREATE FUNCTION ( CREATE_FUNCTION (7))). A simple aggregate function ... UNSAFE are the same as in CREATE FUNCTION . An aggregate will n…creating a new procedural language is: CREATE FUNCTION plsample_call_handler() RETURNS language_handler ... ALSO ALTER LANGUAGE ( ALTER_LANGUAGE (7)), CREATE FUNCTION ( CREATE_FUNC…argument modes and names SEE ALSO CREATE FUNCTION ( CREATE_FUNCTION (7)), ALTER FUNCTION ( ALTER_FUNCTIONALSO ALTER CONVERSION ( ALTER_CONVERSION (7)), CREATE FUNCTION ( CREATE_FUNCTION (7)), DROP CONVERSION ( DROP_CONVERSIONPostgreSQL extension, too. SEE ALSO CREATE FUNCTION ( CREATE_FUNCTION (7)), CREATE TYPE ( CREATE_TYPEDROP TRIGGER ( DROP_TRIGGER (7)), CREATE FUNCTION ( CREATE_FUNCTION (7)), SET CONSTRAINTS ( SET_CONSTRAINTSEVENT TRIGGER ( DROP_EVENT_TRIGGER (7)), CREATE FUNCTION ( CREATE_FUNCTIONfunctions for an existing base type: CREATE FUNCTION mytypesend(mytype) RETURNS bytea ...; CREATE FUNCTION mytyperecvoption for the same variable (see CREATE FUNCTION ( CREATE_FUNCTION (7))), the effectswithout a column definition list: CREATE FUNCTION distributors(int) RETURNS SETOF distributors AS $$ SELECT * FROM ... name -----+------------- 111 | Walt Disney CREATE FUNCTION di…must have been previously defined using CREATE FUNCTION and must be defined to acceptstring literal, just as in CREATE FUNCTION . Use of a dollar-quoted literal is recommended