/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

0 vote142 views1 answer
Windows aggregate functions in postgresql
SQL
1 vote145 views1 answer
Mysql add fields
SQL
11 votes136 views4 answers
MYSQL LOGIN
SQL
0 vote170 views2 answers
Clauses in mysql
SQL
4 votes149 views1 answer
W3schools create table
SQL
0 vote164 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote130 views2 answers
Sql count number of rows after group by
SQL
6 votes158 views3 answers
Mysql remove user privileges
SQL
2 votes128 views1 answer
Oracle sql drop table purge
SQL
4 votes141 views2 answers
Mysql show indexes on table
SQL