Re: Record last SELECT on a row?

Greg Sabino Mullane <htamfids@gmail.com>

From: Greg Sabino Mullane <htamfids@gmail.com>

To: Matthias Leisi <matthias@leisi.net>

Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>

Date: 2025-12-17T12:42:41Z

Lists: pgsql-general

On Wed, Dec 17, 2025 at 2:41 AM 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