public inbox for [email protected]  
help / color / mirror / Atom feed
From: Vydehi Ganti <[email protected]>
To: Dominique Devienne <[email protected]>
Cc: Laurenz Albe <[email protected]>
Cc: [email protected]
Subject: Re: Clarification on RLS policy
Date: Fri, 25 Apr 2025 18:50:46 +0530
Message-ID: <CAMH-PzW2aAC2cVGoLfKxU2dLx-_dwz+Y47zN9f8jHjTifUhT+Q@mail.gmail.com> (raw)
In-Reply-To: <CAFCRh-8_fXc-96mVtuW7=9CeXWW5duopnOdMVCXrbPjJ_aMD9Q@mail.gmail.com>
References: <CAMH-PzUPN7JcLXJx-aJzGnJD2T-aSMo8gaMFkzO_x26urpMqSA@mail.gmail.com>
	<[email protected]>
	<CAFCRh-_fXGfKk6b26xaDD1fg5OhLy92bNofmeDfX2TFjkQLLXA@mail.gmail.com>
	<CAMH-PzXe7AR2QDCDx3eRZPMGuixfTwm3sLF3kMZQkyNhtu=5qQ@mail.gmail.com>
	<CAFCRh-8_fXc-96mVtuW7=9CeXWW5duopnOdMVCXrbPjJ_aMD9Q@mail.gmail.com>

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, <[email protected]> wrote:

> On Fri, Apr 25, 2025 at 3:01 PM Vydehi Ganti <[email protected]> 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.
>


view thread (10+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Clarification on RLS policy
  In-Reply-To: <CAMH-PzW2aAC2cVGoLfKxU2dLx-_dwz+Y47zN9f8jHjTifUhT+Q@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox