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

4 votes170 views2 answers
Dbms output
SQL
0 vote155 views1 answer
Oracle flush Shared Pool
SQL
6 votes142 views1 answer
Oracle trigger after logon on database
SQL
7 votes152 views1 answer
Query postgres delete duplicates
SQL
1 vote121 views1 answer
Strict in postgres SQL
SQL
0 vote157 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
3 votes160 views1 answer
Postgres select max value
SQL
0 vote168 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote147 views1 answer
Sql get user account
SQL
0 vote145 views1 answer
Write sql query to show the details start from digit
SQL