如果我使用文本資料型別宣告了一個變數，我如何將它型別轉換為 bigInt
請指教。
代碼是 -
CREATE or REPLACE PROCEDURE "master_packs".procCheckUpdateAdd1("IMEI" text, battery_pack_number text)
language 'plpgsql' AS
$BODY$
declare
retval text;
begin
INSERT INTO "master_packs".list("serialNumber","assetName") VALUES("IMEI",battery_pack_number)
ON CONFLICT DO NOTHING;
update "master_packs".list SET "assetName" = battery_pack_number where "serialNumber" = "IMEI";
-- update list SET "assetName" = "IMEI" where battery_pack_number = "assetName";
end;
$BODY$;
CAST "serialNumber" AS bigint;
請指教。
uj5u.com熱心網友回復：
嘗試這個 -
select Cast ('4632784672834673288' as bigint)
在做任何事情之前閱讀檔案......
https://www.postgresqltutorial.com/postgresql-cast/
uj5u.com熱心網友回復：
CREATE or REPLACE PROCEDURE "master_packs".procCheckUpdateAdd1("IMEI" text, battery_pack_number text)
language 'plpgsql' AS
$BODY$
declare
retval text;
begin
INSERT INTO "master_packs".list("serialNumber","assetName") VALUES("IMEI"::bigint,battery_pack_number)
ON CONFLICT DO NOTHING;
update "master_packs".list SET "assetName" = battery_pack_number where "serialNumber" = "IMEI"::bigint;
-- update list SET "assetName" = "IMEI" where battery_pack_number = "assetName";
end;
$BODY$;
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/331615.html
標籤：sql PostgreSQL 铸件 plpgsql
上一篇：將表映射到集合