I built an index on a jsonb column of a table with RLS enabled but it was not being used. Turns out the the function jsonb_contains needed to be LEAKPROOF (thanks Joe Conway). However I do not actually know if jsonb_contains is LEAKPROOF. Who's responsibility is it to insure functions are leakproof? It would be useful if this function was documented and there was an indication as to it's leakproofness.
Ted -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
