Hey, can I apply two conditions to a RLS statement using

OR

? like this:

((is_public = true) OR (uid() = user_id))

Hello @Prodigy7kX! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

Yes, you can. You can use any SQL statement for an RLS policy as long as it returns a boolean

Prodigy7kX (2022-03-22)

How would i make something like this work? I did some googling and tried a bunch of stuff but i couldn't get it to work...

What error are you getting when you tried what you have above?

no errors, I'm just not getting rows where

is_public = false

Flip the query and it should work

((uid() = user_id) OR (is_public = true))

lemme check

The user you are using to get the data is allowed to view those rows?

yep

There's definitely something else going on with your table. Try running this in the SQL console:

sql
SELECT
    column_name,
    data_type,
    column_default AS default_value,
    is_generated
FROM
    information_schema.columns
WHERE
    table_name = 'users'
    AND table_schema = 'public'

(replace the

table_name

and

table_schema

with appropriate values) That'll tell us how your table is structured, as well as what the data type of each column is.

ok