MIME-Version: 1.0
From: Shaozhong SHI <shishaozhong@gmail.com>
Date: Thu, 6 Jul 2023 22:47:12 +0100
Message-ID: 
 <CA+i5Jwa9E1RyApZYViBgG9yyCRT5V4WKRAeWDXuVe_1qf4uCsA@mail.gmail.com>
Subject: How do Exception, do nothing and carry on
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000001d467905ffd87621"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bi5Jwa9E1RyApZYViBgG9yyCRT5V4WKRAeWDXuVe_1qf4uCsA%40mail.gmail.com>
Precedence: bulk

--0000000000001d467905ffd87621
Content-Type: text/plain; charset="UTF-8"

The function in the following block code may fail.

How to make it to carry on by ignoring exception?

Something like Python's try catch.

for i in (select distinct id from id_table)
  loop
         raise notice '%', i;
           insert into my_table(id, last, arr, count) SELECT i, * from
my_function(i) f(last int, arr int[], count int);
           commit;

  end loop;

--0000000000001d467905ffd87621
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div>The function in the following block =
code may fail.</div><div><br></div><div>How to make it to carry on by ignor=
ing exception?</div><div><br></div><div>Something like Python&#39;s try cat=
ch.</div><div><br></div><div>for i in (select distinct id from id_table)=C2=
=A0</div><div>=C2=A0 loop</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0raise=
 notice &#39;%&#39;, i;</div><div><span style=3D"white-space:normal"><span =
style=3D"white-space:pre">		</span></span></div><div>=C2=A0 =C2=A0<span sty=
le=3D"white-space:pre">	</span>=C2=A0 =C2=A0 =C2=A0 =C2=A0insert into my_ta=
ble(id, last, arr, count) SELECT i, * from my_function(i) f(last int, arr i=
nt[], count int);</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0commit=
;</div><div><br></div><div>=C2=A0 end loop;</div></div></div>

--0000000000001d467905ffd87621--