/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

28 votes225 views6 answers
Sql update
SQL
0 vote195 views1 answer
Drop all tables db2
SQL
1 vote200 views1 answer
How much every mysql database record takes from diskspace
SQL
13 votes200 views3 answers
Sql select from multiple tables without join
SQL
0 vote204 views1 answer
Sql set data from a select query to a temp table and insert
SQL
0 vote195 views1 answer
Oracle db get table sizes
SQL
5 votes235 views2 answers
Postgresql add not null constraint
SQL
0 vote218 views1 answer
Database db connection string format
SQL
9 votes204 views5 answers
Sql limit
SQL
1 vote211 views2 answers
Test sqlsrv connection
SQL