Re: Clarification on RLS policy - Mailing list pgsql-general

From Vydehi Ganti
Subject Re: Clarification on RLS policy
Date
Msg-id CAMH-PzW2aAC2cVGoLfKxU2dLx-_dwz+Y47zN9f8jHjTifUhT+Q@mail.gmail.com
Whole thread Raw
In response to Re: Clarification on RLS policy  (Dominique Devienne <ddevienne@gmail.com>)
Responses Re: Clarification on RLS policy
List 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 by date:

Previous
From: Dominique Devienne
Date:
Subject: Re: Clarification on RLS policy
Next
From: Dominique Devienne
Date:
Subject: Re: Clarification on RLS policy