/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

10 votes135 views4 answers
Drop primary key
SQL
2 votes140 views1 answer
Get hour from date sql
SQL
0 vote140 views1 answer
Flask sqlalchemy remove duplicates
SQL
11 votes142 views2 answers
Having clause in sql
SQL
1 vote132 views1 answer
Mysqli connect
SQL
0 vote125 views1 answer
The local psql command could not be located
SQL
0 vote147 views1 answer
How to locate pg_hba.conf file
SQL
1 vote158 views1 answer
Nvl postgres
SQL
0 vote138 views2 answers
Sql update top 100
SQL
19 votes131 views1 answer
Sqrt(-1)
SQL