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

From Vydehi Ganti
Subject Re: Clarification on RLS policy
Date
Msg-id CAMH-PzUBLFXsNPeovtg1iLf=HqOxzgTBn+6iToPNnOY0ds9b=A@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

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 by date:

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