Well I seems I got it working. Still not sure what I did wrong.
I finally got it working by moving the sub select into a view and only use
the view in the policy:
(u): ((hs_group_id IS NULL) OR (hs_group_id IN ( SELECT
allowed_hs_groups.hs_group_id
FROM allowed_hs_groups)))
The allowed_hs
Hi list!
I am a long postgres user but only since a short time I am using the more
advanced stuff. And now I use the row level security I run into a problem.
I use postgres 9.5.12. I have multiple users; postgres, root and ivo. I
have a table called person. It contains multiple rows that should b