/SQL/Postgresql stored procedure update table values

Postgresql stored procedure update table values

CREATE OR REPLACE FUNCTION change_account_email(
  IN oldAddr VARCHAR(50),
  IN newAddr VARCHAR(50))
RETURNS INTEGER AS 
$$
DECLARE
  rcount INTEGER DEFAULT 0;
BEGIN
  UPDATE accounts
     SET a_email = newAddr
   WHERE a_email = oldAddr;
   GET DIAGNOSTICS rcount = ROW_COUNT;
   RETURN rcount;
END;
$$
LANGUAGE plpgsql;

Source: stackoverflow.com

Similar codes

20 votes297 views3 answers
SQL query rename table
SQL
0 vote286 views1 answer
Mariadb used space
SQL
0 vote287 views1 answer
Dasebase_url-postgres for windows
SQL
0 vote322 views1 answer
Mysql faster delete
SQL
3 votes283 views3 answers
Into in sql
SQL
0 vote302 views1 answer
Sql composite key
SQL
1 vote298 views1 answer
Select from describe sql
SQL
0 vote312 views1 answer
Psql show db
SQL
0 vote310 views1 answer
Asp.net core sql server stored procedure
SQL
2 votes299 views1 answer
Postgresql left join distinct on
SQL