Re: Record last SELECT on a row?

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Record last SELECT on a row?
Дата
Msg-id CAKAnmmJP4LN7tJtEW7GtSJ7ztOVf3kak1TZD_8KxAakk1b0fBw@mail.gmail.com
обсуждение исходный текст
Ответ на Record last SELECT on a row?  (Thiemo Kellner <thiemo@gelassene-pferde.biz>)
Список 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 по дате отправления: