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

From Dominique Devienne
Subject Re: Clarification on RLS policy
Date
Msg-id CAFCRh-9+65e25FCzGbO9W-LXX1Bcf-LYVec-F5br6ZvmcyTv1A@mail.gmail.com
Whole thread Raw
In response to Re: Clarification on RLS policy  (Vydehi Ganti <rayudugs@gmail.com>)
Responses Re: Clarification on RLS policy
List pgsql-general
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: Vydehi Ganti
Date:
Subject: Re: Clarification on RLS policy
Next
From: Vydehi Ganti
Date:
Subject: Re: Clarification on RLS policy