/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 vote360 views2 answers
Remove mysql workbench ubuntu
SQL
1 vote313 views1 answer
Rows to comma separated values in mssql
SQL
0 vote299 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
3 votes293 views1 answer
How to check schema privileges in oracle
SQL
0 vote339 views1 answer
Copy row from db to db mysql
SQL
2 votes256 views2 answers
Mysql get last character of string
SQL
0 vote323 views1 answer
Influxdb clone measurement
SQL
1 vote307 views2 answers
Datetrunc hour snowflake
SQL
0 vote284 views1 answer
Create table employees oracle
SQL
8 votes316 views10 answers
Sql
SQL