MIME-Version: 1.0
References: <287E4DF6-35A2-4062-AEBA-32DB1DE35C5D@leisi.net>
In-Reply-To: <287E4DF6-35A2-4062-AEBA-32DB1DE35C5D@leisi.net>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Wed, 17 Dec 2025 07:42:41 -0500
Message-ID: <CAKAnmmK_9NaPeDtpfyJu7_TtLbEEPmMQGL9GLUQgB8cSZsLadA@mail.gmail.com>
Subject: Re: Record last SELECT on a row?
To: Matthias Leisi <matthias@leisi.net>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003becbe06462530a2"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmK_9NaPeDtpfyJu7_TtLbEEPmMQGL9GLUQgB8cSZsLadA%40mail.gmail.com>
Precedence: bulk

--0000000000003becbe06462530a2
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Dec 17, 2025 at 2:41=E2=80=AFAM Matthias Leisi <matthias@leisi.net>=
 wrote:

> The table contains some ten thousand rows, five columns, and we already
> record created / last updated using triggers.

 ...

> Any other ways this could be achieved?
>

It depends a lot on how the table is accessed, but you could use a function
(or group of functions) that returns the information from the table, and
along the way, updates the requested metadata.


Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

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

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Dec 17, 2025 at 2:41=E2=80=AFAM M=
atthias Leisi &lt;<a href=3D"mailto:matthias@leisi.net">matthias@leisi.net<=
/a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><block=
quote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1=
px solid rgb(204,204,204);padding-left:1ex">The table contains some ten tho=
usand rows, five columns, and we already record created / last updated usin=
g triggers.</blockquote><div>=C2=A0...</div><blockquote class=3D"gmail_quot=
e" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204)=
;padding-left:1ex">Any other ways this could be achieved?<br></blockquote><=
div><br></div><div>It depends a lot on how the table is accessed, but you c=
ould use a function (or group of functions) that returns the information fr=
om the table, and along the way, updates the requested metadata.</div><div>=
<br></div><div>=C2=A0</div></div><div dir=3D"ltr" class=3D"gmail_signature"=
><div dir=3D"ltr"><div>Cheers,</div><div>Greg</div><div><br></div><div>--</=
div><div>Crunchy Data - <a href=3D"https://www.crunchydata.com" target=3D"_=
blank">https://www.crunchydata.com</a></div><div>Enterprise Postgres Softwa=
re Products &amp; Tech Support</div><div><br></div></div></div></div>

--0000000000003becbe06462530a2--