/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 vote178 views2 answers
Sql truncate number
SQL
0 vote137 views1 answer
Mysql earlier than date
SQL
-1 vote154 views1 answer
Window functions in sql
SQL
3 votes148 views1 answer
Mysql set field unique
SQL
1 vote155 views1 answer
Mysql select if empty result
SQL
0 vote155 views1 answer
SQL: calculate hours from two dates
SQL
0 vote144 views1 answer
Add sqlite3 in lumen
SQL
21 votes144 views3 answers
Sql average
SQL
1 vote164 views1 answer
Psql connect to another database
SQL
3 votes170 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL