Re: Clarification on RLS policy

From: Dominique Devienne <ddevienne(at)gmail(dot)com>
To: Vydehi Ganti <rayudugs(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Clarification on RLS policy
Date: 2025-04-25 13:25:59
Message-ID: CAFCRh-9+65e25FCzGbO9W-LXX1Bcf-LYVec-F5br6ZvmcyTv1A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Apr 25, 2025 at 3:21 PM Vydehi Ganti <rayudugs(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vydehi Ganti 2025-04-25 13:28:52 Re: Clarification on RLS policy
Previous Message Vydehi Ganti 2025-04-25 13:20:46 Re: Clarification on RLS policy