Re: Clarification on RLS policy

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

So I don't have a possibility to append where clause dynamically and can only check the boolean?

On Fri, 25 Apr, 2025, 18:48 Dominique Devienne, <ddevienne@gmail.com> wrote:
On Fri, Apr 25, 2025 at 3:01 PM Vydehi Ganti <rayudugs@gmail.com> wrote:
> Then it should build up the lPredicate with the filter condition and append to the query user runs on the Activity table.

You're not reading us, and asking us to do the work for you...
RLS Predicates don't return strings in PostgreSQL, but a boolean.
Write your function to do your check, and return TRUE or FALSE.

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