Search Postgresql Archives

Re: Clarification on RLS policy

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> wrote:
On Fri, Apr 25, 2025 at 3:21 PM Vydehi Ganti <rayudugs@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux