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 1jsyoF-0003ih-5e for pgsql-admin@arkaria.postgresql.org; Wed, 08 Jul 2020 01:23:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jsyoE-00019V-4d for pgsql-admin@arkaria.postgresql.org; Wed, 08 Jul 2020 01:23:38 +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 1jsyoD-00019N-Qo for pgsql-admin@lists.postgresql.org; Wed, 08 Jul 2020 01:23:37 +0000 Received: from mail-oi1-x235.google.com ([2607:f8b0:4864:20::235]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jsyoB-0000nq-NL for pgsql-admin@lists.postgresql.org; Wed, 08 Jul 2020 01:23:36 +0000 Received: by mail-oi1-x235.google.com with SMTP id k4so36474439oik.2 for ; Tue, 07 Jul 2020 18:23:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=h0J2Rgbbnt24kmZYcLjWTyWiDCk8lYvELl+f67SZdr8=; b=NT6/f64ugKaKU7xe5cyWCwFj8OBzXv89oZyIKXu2pdiRPT5/wR0GsnKIhzXXuh36mw hL5FYmbFE5qzqJpo9ThdfO7jigNMK4rcccRMeEKLW24Q7IKMtNHJH+D8GvGtGq5ghyOu r4YrL/0ogx6Yze0DQT/ibJGsUbd0vMiGal5iVdszItTQ+34//kR0eNz9ikXlTzRzWB6o lsVbsdMC6Oi0zrwkiIPddQzmoav0oM9exSqQBTp+779fTAC7WJzVQz+MJeAxe4FYGeQA M6BDlcVGCBFiD/Nbi5DgERGxViuuin31ybkVLH31ieRoeAPGbXO5SP9kNcw9OZD7D0RA L84g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=h0J2Rgbbnt24kmZYcLjWTyWiDCk8lYvELl+f67SZdr8=; b=PWvXqkmOUOJBledV5+ao3E5YA4jS5QR5eDoe2fYXee8kUYzPwivj30SdquJt7Q+q8F JGrwEq4vD5DfaM2ZCoWLxCZWrnoZbZwLzCePlAKAi6JoPukWyawtAjyFqYxCZtEw3ieb Z5whl5ux7HKkabZb2o8E5rxV+KJY4HZUlyy5MHuj60U1R1CqlewkJ8BMFqX8so3PAjnL tDlrbw6T0Qr+1vyYqg4u/LDSO0xm6+coZi+SNL1ZPQhmdgurOZISmemv+yXc0PUl74uW ENIgNYEAFZ8rNtspU/VIipbJ8C/Q8dL6qx2Y/RfZ328D8Hcdg1Kq1ombBoSTS8sc3ZsJ nVAA== X-Gm-Message-State: AOAM530B59Qx8VPRioTmdqKpWahz6L5svR8RjKIdNqfnovhm2m7dFZU1 RywR6u61EwlW9gEhWornhmRl3OMp96sxmw== X-Google-Smtp-Source: ABdhPJwtlCrrgI8bKm5dk5FVLrwz+0x0giDSf48DfraxmasqOFqvKUptKjcBFGKgNHcNudvedBfhVA== X-Received: by 2002:a05:6808:9a3:: with SMTP id e3mr5622364oig.63.1594171414359; Tue, 07 Jul 2020 18:23:34 -0700 (PDT) Received: from [192.168.1.10] (ip70-186-126-197.no.no.cox.net. [70.186.126.197]) by smtp.googlemail.com with ESMTPSA id z17sm432657oic.32.2020.07.07.18.23.33 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 07 Jul 2020 18:23:33 -0700 (PDT) Subject: Re: SELECTing from a function where i don't want the results To: pgsql-admin@lists.postgresql.org References: <911059a0-d138-7ea3-044e-0d7ca71755a2@gmail.com> From: Ron Message-ID: <523b3669-3969-b6f3-2f9e-c4dd043c8167@gmail.com> Date: Tue, 7 Jul 2020 20:23:32 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.8.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Especially since deleting one row at a time is very slow. On 7/7/20 8:06 PM, Scott Ribe wrote: >> On Jul 7, 2020, at 6:48 PM, Wells Oliver wrote: >> >> Yes: it returns one row per record for deletion with a deleted row count, and is called for hundreds (sometimes thousands) of records. > Why not write a function that works the way you want? -- Angular momentum makes the world go 'round.