Plpgsql create function

postgres=# Create or replace function fun1(n int) returns int 

as

$$

Begin

Insert into test values (n,'2019-11-26');

Return 1;

End;

$$

Language 'plpgsql';

CREATE FUNCTION

postgres=#

Source: enterprisedb.com

Similar codes

0 vote207 views1 answer
Month mysql
SQL
0 vote248 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote257 views1 answer
Compare field sql server
SQL
0 vote248 views1 answer
Create dump file mysql workbench
SQL
0 vote235 views1 answer
Test connection to sql server
SQL
10 votes232 views5 answers
Between keyword in sql
SQL
1 vote253 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote226 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
25 votes297 views5 answers
Mysql replace text
SQL
0 vote226 views1 answer
Reading from right to left from string find first special characters in sql
SQL