Re: Record last SELECT on a row? - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Record last SELECT on a row?
Date
Msg-id CAKAnmmK_9NaPeDtpfyJu7_TtLbEEPmMQGL9GLUQgB8cSZsLadA@mail.gmail.com
Whole thread Raw
In response to Record last SELECT on a row?  (Matthias Leisi <matthias@leisi.net>)
List 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

--
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Record last SELECT on a row?
Next
From: "David G. Johnston"
Date:
Subject: Re: Record last SELECT on a row?