Received-SPF: pass (ha01s018.org-dns.com: connection is authenticated)
Date: Wed, 17 Dec 2025 18:14:33 +0100 (GMT+01:00)
From: Thiemo Kellner <thiemo@gelassene-pferde.biz>
To: pgsql-general@lists.postgresql.org
Message-ID: <8567de96-062f-416a-9d19-f14abfdc925e@gelassene-pferde.biz>
In-Reply-To: <287E4DF6-35A2-4062-AEBA-32DB1DE35C5D@leisi.net>
References: <287E4DF6-35A2-4062-AEBA-32DB1DE35C5D@leisi.net>
Subject: Record last SELECT on a row?
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1_219606990.1765991673612"
Archived-At: <https://www.postgresql.org/message-id/8567de96-062f-416a-9d19-f14abfdc925e%40gelassene-pferde.biz>
Precedence: bulk

------=_Part_1_219606990.1765991673612
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Hi

I wonder whether a view calling a set returning function would be a viable option. Within the function you execute the actual query twice. Once to merge selected pk into a protocol table and once for the return of the data set.

Cheers

Thiemo

------=_Part_1_219606990.1765991673612
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
 <head>
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
 </head>
 <body>
  <span dir="ltr" style="margin-top:0; margin-bottom:0;">Hi</span>
  <br>
  <br><span dir="ltr" style="margin-top:0; margin-bottom:0;">I wonder whether a view calling a set returning function would be a viable option. Within the function you execute the actual query twice. Once to merge selected pk into a protocol table and once for the return of the data set.</span>
  <br>
  <br><span dir="ltr" style="margin-top:0; margin-bottom:0;">Cheers</span>
  <br>
  <br><span dir="ltr" style="margin-top:0; margin-bottom:0;">Thiemo</span>
  <br>
 </body>
</html>
------=_Part_1_219606990.1765991673612--