| From: | Greg Sabino Mullane <htamfids(at)gmail(dot)com> |
|---|---|
| To: | Matthias Leisi <matthias(at)leisi(dot)net> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Record last SELECT on a row? |
| Date: | 2025-12-17 12:42:41 |
| Message-ID: | CAKAnmmK_9NaPeDtpfyJu7_TtLbEEPmMQGL9GLUQgB8cSZsLadA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Dec 17, 2025 at 2:41 AM Matthias Leisi <matthias(at)leisi(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2025-12-17 13:26:20 | Re: Record last SELECT on a row? |
| Previous Message | Laurenz Albe | 2025-12-17 08:41:17 | Re: Record last SELECT on a row? |