Prodigy7kX
03/22/2022, 2:49 AMOR
?
like this: ((is_public = true) OR (uid() = user_id))
Needle
03/22/2022, 2:49 AM/title
command!
We have solved your problem?
Click the button below to archive it.Scott P
03/22/2022, 2:51 AMNeedle
03/22/2022, 2:51 AMProdigy7kX
03/22/2022, 3:15 AMsilentworks
03/22/2022, 10:33 AMProdigy7kX
03/22/2022, 2:37 PMis_public = false
is_public = true
or uid() = user_id
, if either of these is true I should be able to select the rowsilentworks
03/22/2022, 6:41 PM((uid() = user_id) OR (is_public = true))
Prodigy7kX
03/22/2022, 6:44 PMsilentworks
03/22/2022, 7:08 PMProdigy7kX
03/22/2022, 7:43 PMScott P
03/22/2022, 7:50 PMsql
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.Prodigy7kX
03/22/2022, 8:02 PM