Re: Clarification on RLS policy

Поиск
Список
Период
Сортировка
От Vydehi Ganti
Тема Re: Clarification on RLS policy
Дата
Msg-id CAMH-PzUBLFXsNPeovtg1iLf=HqOxzgTBn+6iToPNnOY0ds9b=A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Clarification on RLS policy  (Dominique Devienne <ddevienne@gmail.com>)
Ответы Re: Clarification on RLS policy
Список pgsql-general

Can i know if there is any scenario or ref document for the design you suggested above?

On Fri, 25 Apr, 2025, 18:56 Dominique Devienne, <ddevienne@gmail.com> wrote:
On Fri, Apr 25, 2025 at 3:21 PM Vydehi Ganti <rayudugs@gmail.com> wrote:
> So I don't have a possibility to append where clause dynamically and can only check the boolean?

Indeed. But given that you can run arbitrary SQL inside the function,
even dynamic SQL,
that ends up pretty much the same. And you have access to in-row
values too, when calling the function.
It's just a different design, that's all. --DD

В списке pgsql-general по дате отправления: