DEFINITIONS

Definitions More Info.
Definition ID2.017
TitlePOSTGRESQL
CategoryNOTES
DefinitionDisaridan Parametreli Fonksiyon Function Delete
Definition Description--Asagidaki fonksiyon, disaridan 1 parametre alarak, istedigin kadar silme yaptirabiliryorsun

CREATE OR REPLACE FUNCTION "PushNotification"."DeleteFunction3"(s INTEGER)
RETURNS integer
LANGUAGE 'plpgsql'

COST 100
VOLATILE
AS $BODY$
DECLARE i INTEGER;
BEGIN i := 0;
WHILE( i <=s ) loop
DELETE FROM "PushNotification"."PushNotificationLog"
Where "Id" in (SELECT "Id"
FROM "PushNotification"."PushNotificationLog"
Where "CreationDate"<=(CURRENT_TIMESTAMP - INTERVAL '45 day')
Order by "Id"
limit 1000000);
i = i + 1;
END loop;
RETURN i;
END;
$BODY$;

ALTER FUNCTION "PushNotification"."DeleteFunction"()
OWNER TO postgres;
RecordBycunay
Record Date10-04-2020 20:35:31
Düzenle
Kopyala
Sil