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 1jsyv4-0003yJ-Dk for pgsql-admin@arkaria.postgresql.org; Wed, 08 Jul 2020 01:30:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jsyv3-00021H-Dk for pgsql-admin@arkaria.postgresql.org; Wed, 08 Jul 2020 01:30:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jsyv3-0001zD-5w for pgsql-admin@lists.postgresql.org; Wed, 08 Jul 2020 01:30:41 +0000 Received: from mail-pf1-x431.google.com ([2607:f8b0:4864:20::431]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jsyv0-0001NO-I6 for pgsql-admin@lists.postgresql.org; Wed, 08 Jul 2020 01:30:40 +0000 Received: by mail-pf1-x431.google.com with SMTP id 1so1520776pfn.9 for ; Tue, 07 Jul 2020 18:30:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=1eEI+toS+wg0eLw1MtgdlgiohJ3lOhtCR46iH1LZpp0=; b=oiEjk9HFCeEnmd6zilGJ6cRvm3gRG0+GCoeRV4yZhe0WcBCy3vwCMn6sFK/ePcLzN+ kelbtNPY4G6MDnNWdKGOZNmfS4HUKB7OmR9jF55HrMVt4kqqhZNltigrfBzBhUbFtjo7 yizAg89P7y8LyRurjWEUHblTvL8it2lteJ7qTnqoQiyJMlvGr2aJSOBipT6s1A72+Odp nv7SILLQ7AfMb18KhU6OWyqlbupWiDrV9IjQr6/aTDGU0E80VyUOhxpXCjhXlymuJFYE MBsPDnUZfmdaOlSE64C03JQ9SQyrOxuGjrY/O3JQwa2PbQn5gnfSXjmQWZtmjj+e67ep 1fUg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=1eEI+toS+wg0eLw1MtgdlgiohJ3lOhtCR46iH1LZpp0=; b=M+DnxPiq3Er+HnFL4ffma9q4/kUYM7X0hC7REWIxks4j0FpShxsCl0aziMLzm5LrbC IKw0XFCi8wJFpX4+ZgOolA3ElpOEGNe3ENHkBkfqPeRQR6vW41/MTMmeW3TUFspgvMQU f118bbU2zDUnVM7rgN/2nPGRujrscGZmQ7ge1pV6hcUCVsjM2ACiSa5Mr+yI0ZNM61dn nQaTHDaY6uIX9hVmLasD5Kv2lrqS9aB/5/a3rvNzpbIcsx8JTlklB5bmK8efUycElqw7 sV7nN9n8UUUgaFXOfWugmxnI8b/InfbwThQMxBxY35SKejR+JFW2FMUS4qmt47c797Im s81A== X-Gm-Message-State: AOAM532hSvFDvAgCTOaHC1uXkXgDYyxB6td/DIAWVsBtywBQ02StJHey X1KP/SVTqIluLKVf23komSnCTR/P5Ms= X-Google-Smtp-Source: ABdhPJxuIt4wNUwiEjXzRi/DDzcWb8hiPxVjjhgF2TJn0PqYP3GyIGgDJVuGxpWs6M0VMEgpyEaZwA== X-Received: by 2002:aa7:9570:: with SMTP id x16mr11950388pfq.124.1594171835511; Tue, 07 Jul 2020 18:30:35 -0700 (PDT) Received: from [10.234.28.27] ([1.136.209.228]) by smtp.gmail.com with ESMTPSA id e195sm21142819pfh.218.2020.07.07.18.30.34 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 07 Jul 2020 18:30:34 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (1.0) Subject: Re: SELECTing from a function where i don't want the results From: Jim Gmail X-Mailer: iPhone Mail (16G192) In-Reply-To: <6AB3C50F-1020-4BE5-AC5B-576009310954@elevated-dev.com> Date: Wed, 8 Jul 2020 11:30:32 +1000 Cc: Wells Oliver , Ron , pgsql-admin@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <911059a0-d138-7ea3-044e-0d7ca71755a2@gmail.com> <6AB3C50F-1020-4BE5-AC5B-576009310954@elevated-dev.com> To: Scott Ribe List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Perhaps the OP could supply the function definition to make things clearer. Sent from my iPhone On 8 Jul 2020, at 11:24, Scott Ribe wrote: >> On Jul 7, 2020, at 7:14 PM, Wells Oliver wrote: >>=20 >> Sorry guys, it works exactly the way I want, just wanted to suppress its o= utput when called for thousands of rows. Apologies if I wasn't clear enough.= >=20 > It seems that it doesn't work the way you want, because it can output thou= sands of rows ;-) >=20 >=20 >=20