/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

1 vote137 views1 answer
Postgres reset auto increment
SQL
-1 vote181 views1 answer
How to switch user in mysql
SQL
0 vote135 views1 answer
Bigquery information_schema schema all columns
SQL
4 votes181 views1 answer
Postgres delete last row
SQL
0 vote296 views1 answer
How to update random rows in sql
SQL
0 vote179 views1 answer
Stored procedures example
SQL
0 vote204 views4 answers
Forenkey code alchemy sql
SQL
0 vote189 views1 answer
Postgres statistics
SQL
7 votes221 views2 answers
Sql remove duplicates based on column
SQL
10 votes239 views4 answers
Else if mysql
SQL