Shulou(Shulou.com)05/31 Report--

What this article shares with you is about how to update records in batches in postgresql. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

The code is as follows:

CREATE FUNCTION updateTchrNm () RETURNS void AS

$body$

DECLARE

Rownum integer: = 1

BEGIN

While rownum

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.