Search Postgresql Archives

Re: Clarification on RLS policy

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

 



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

[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