/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

12 votes361 views6 answers
Distinct in sql server
SQL
28 votes285 views6 answers
Distinct sql
SQL
0 vote309 views1 answer
H2 auto increment and unique
SQL
0 vote325 views1 answer
Sqlite to csv statement
SQL
8 votes327 views2 answers
Select table column name in sql
SQL
0 vote330 views1 answer
Sql count matching group by
SQL
0 vote326 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote360 views1 answer
Create a view in sqlite
SQL
1 vote317 views1 answer
Mysql query bulk insert
SQL
0 vote330 views1 answer
Call function sql oracle with output put line
SQL