Jong-won Choi <jongwon@xxxxxxxxxxxxxxx> writes: > I have a RLS policy definition like: > CREATE POLICY promoter_policy ON Agency > USING (promoter in build_valid_promoter_list()) > WITH CHECK (promoter in build_valid_promoter_list()); That's failing basic SQL expression syntax: the RHS of "IN" has to be a parenthesized sub-select or array value. You'd have better luck with (promoter in (select * from build_valid_promoter_list())) ... syntax-wise, at least. I'm not sure if we allow sub-selects in RLS conditions. Personally I'd write that more like USING (check_valid_promoter(promoter)) with that function being defined in the obvious way. There's little reason to enumerate the entire set of valid promoters if you only need to find out whether one specific value is one. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
