| From: | Greg Sabino Mullane <htamfids(at)gmail(dot)com> |
|---|---|
| To: | Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Record last SELECT on a row? |
| Date: | 2025-12-17 17:23:31 |
| Message-ID: | CAKAnmmJP4LN7tJtEW7GtSJ7ztOVf3kak1TZD_8KxAakk1b0fBw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Dec 17, 2025 at 12:14 PM Thiemo Kellner <thiemo(at)gelassene-pferde(dot)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
--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Korot | 2025-12-17 17:38:38 | Re: PQexecPrepared() question |
| Previous Message | Ron Johnson | 2025-12-17 17:23:15 | Re: wal segment size |