|
postgres=# CREATE FUNCTION "mixed" () RETURNS integer AS '
postgres'# DecLarE
postgres'# --assigns 1 to the oNe variable
postgres'# oNe IntEgER
postgres'# := 1;
postgres'#
postgres'# bEGiN
postgres'#
postgres'# --displays the value of oNe
postgres'# ReTUrn oNe;
postgres'# eNd;
postgres'# ' LANGUAGE 'plpgsql';
CREATE FUNCTION
postgres=#
postgres=# select mixed();
mixed
-------
1
(1 row)
postgres=#
|