Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qJxaQ-0008GM-Aj for pgsql-sql@arkaria.postgresql.org; Thu, 13 Jul 2023 14:46:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qJxaO-0002FJ-Ka for pgsql-sql@arkaria.postgresql.org; Thu, 13 Jul 2023 14:46:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qJxaO-0002F9-Bp for pgsql-sql@lists.postgresql.org; Thu, 13 Jul 2023 14:46:28 +0000 Received: from mail-ed1-x52a.google.com ([2a00:1450:4864:20::52a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qJxaL-000Cl4-78 for pgsql-sql@lists.postgresql.org; Thu, 13 Jul 2023 14:46:27 +0000 Received: by mail-ed1-x52a.google.com with SMTP id 4fb4d7f45d1cf-51bece5d935so978930a12.1 for ; Thu, 13 Jul 2023 07:46:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1689259584; x=1691851584; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=ZHro1VHcaZz633T5yG0Obm7nc/2+fB0HkAWsqQpRzfA=; b=OTbuzyRX7KHiQCnSvOp/5L9kvngi2RuTy1A1YHIDMeSB6R6qA/+y3/wboioODxtr8O kt9nqcs+1dMdU3rXJzSEEBa4RmlXA+LEsNPD0fcrXOk6/4tGzhinLMuBuV9DjidyZHf4 XwhEa7YYxXt7n0CEYXQMeXaBvWl/0BpmLZS9Qq1PdAG775Qb8/so3dY8iNmZSMTSXPlM zW6Mt+kqEVJKy1FgebjKUk8hH5OiWONWnmwckysmVbgFvU5FKBERnlMf6sIDVudToGRv 6R6tUL+EJbov7Ac7H4DpOmQmWt+snVcHCQw38Wlj/zHxb7O3+5niTbSdi60QXTDab23d lSvQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689259584; x=1691851584; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=ZHro1VHcaZz633T5yG0Obm7nc/2+fB0HkAWsqQpRzfA=; b=Pu07nC7jLC1vaBlBWqvHYjplyQbXxFo/1yFUG5YYl1De3NvbwKASR8Au7IJOScOeJW G7oIvG6GJnWMbpSAXiSpBEBJ0SKi87OBLH63xPSLG1LpK5ROfRuFOkyYrTyfDpjPVmGM v9cAJZymXIVIxwDe/Q+d6nZadD6QZnSFa65SbIT7nzQexXjb5kVO+iVu8419p3OwlakJ Pf4annG2ZM+y18FU71eJa7Xa5j0KnB3gUpqI9qF+namuBVJey8gtw3mF3bAniEhDFR51 O5EQ2Q3bU/jcP1h4zgCuMwGJNvxNA3OwQ15rHSxrBtYV2avwmOTr6yw3uHypxgVOTGQx Y/sQ== X-Gm-Message-State: ABy/qLawwDz6bMUAxE9mD8senQvQk34tzocGbooN/JJzhYu3Uaka3DH6 sYxeZH/Gh0C+ny1au0DvtrfxMgL36R38oRtrKKVW5z6M X-Google-Smtp-Source: APBJJlHA8+iKReAtlfohTdth8ARJg4MmSG2IVVnEeF0y4TqDf7ipaC7bN0QsPAnXkmByeUmdSHBwa8oE7v4MHmzaIok= X-Received: by 2002:a17:907:9503:b0:992:b2a:d627 with SMTP id ew3-20020a170907950300b009920b2ad627mr1325377ejc.45.1689259583886; Thu, 13 Jul 2023 07:46:23 -0700 (PDT) MIME-Version: 1.0 From: Shaozhong SHI Date: Thu, 13 Jul 2023 15:46:12 +0100 Message-ID: Subject: Can we set time exception? To: pgsql-sql Content-Type: multipart/alternative; boundary="0000000000006e599406005f65ac" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006e599406005f65ac Content-Type: text/plain; charset="UTF-8" In a Do statement, it calls function to work? Can we set a time exception? If the function responds with result in a given time, we take the result. If the response of the function exceeds the time set, skip it. Regards, David --0000000000006e599406005f65ac Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
In a Do statement, it calls function to work?

Can we set a time exception?

If the functio= n responds with result in a given time, we take the result.

<= /div>
If the response of the function exceeds the time set, skip it.

Regards,

David
--0000000000006e599406005f65ac--