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

From Dominique Devienne
Subject Re: Clarification on RLS policy
Date
Msg-id CAFCRh-8_fXc-96mVtuW7=9CeXWW5duopnOdMVCXrbPjJ_aMD9Q@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:01 PM Vydehi Ganti <rayudugs@gmail.com> 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.



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