maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_ovmrecon_phone()
Parameters
Name
Type
Mode
phonenum
character varying
OUT
Definition
DECLARE counter bigint :=0; BEGIN DROP TABLE IF EXISTS t; CREATE TEMPORARY TABLE t (serialnumber varchar,phonenum varchar); COPY t FROM '/db/ovm_recon/reason_phonenum.csv' header csv; return query UPDATE device d SET unit_name = t.phonenum from t WHERE t.serialnumber = ltrim(d.serialnumber,'0') RETURNING d.serialnumber; END;