Postgresql functions

Create function in postgresql

create [or replace] function function_name(param_list)
   returns return_type 
   language plpgsql
as $$
declare 
-- variable declaration
begin
 -- logic
end;
$$

Source: postgresqltutorial.com

Similar codes

1 vote130 views1 answer
Update substring in mysql
SQL
0 vote126 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
0 vote80 views1 answer
Mysql select top 2
SQL
3 votes72 views1 answer
System.debug apex
SQL
6 votes112 views1 answer
Phpmyadmin password root
SQL
4 votes120 views6 answers
Sql select statement
SQL
6 votes134 views2 answers
Install psql mac
SQL
0 vote174 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
0 vote113 views1 answer
Sql developer connect to sql server
SQL
0 vote111 views1 answer
Apache Derby: Create SQL Dump with data
SQL