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 CAKAnmmJP4LN7tJtEW7GtSJ7ztOVf3kak1TZD_8KxAakk1b0fBw@mail.gmail.com
Whole thread Raw
In response to Record last SELECT on a row?  (Thiemo Kellner <thiemo@gelassene-pferde.biz>)
List pgsql-general
On Wed, Dec 17, 2025 at 12:14 PM Thiemo Kellner <thiemo@gelassene-pferde.biz> wrote:
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.

The view would be sucking in the entire table every time . Maybe not a big deal as this is a very tiny table.

I think Joe wins this thread with the RLS idea however.


Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: wal segment size
Next
From: Igor Korot
Date:
Subject: Re: PQexecPrepared() question