/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 vote131 views1 answer
Count mysql server db tables
SQL
2 votes138 views1 answer
How to find table table in stored procedure sql server
SQL
11 votes152 views4 answers
Reset identity column values in sql server
SQL
11 votes133 views1 answer
Ddl view
SQL
0 vote150 views3 answers
Join
SQL
0 vote141 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
6 votes122 views5 answers
Alter table oracle
SQL
0 vote117 views1 answer
Export partttion and import in oracle
SQL
7 votes131 views3 answers
Postgre describe table
SQL
0 vote118 views1 answer
Truncate table sql server foreign key
SQL