Record last SELECT on a row?

From: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Record last SELECT on a row?
Date: 2025-12-17 17:14:33
Message-ID: 8567de96-062f-416a-9d19-f14abfdc925e@gelassene-pferde.biz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2025-12-17 17:21:03 Re: wal segment size
Previous Message Greg Sabino Mullane 2025-12-17 17:13:33 Re: Record last SELECT on a row?