Using 'new' special variable inside RLS insert policy

[tchief]

There is a handy new special variable that exists in functions that return triggers, which has the record to be inserted. So new.name would get name column of row to be inserted.

When creating a new RLS insert policy from UI, the whole record is 'unwrapped', so name could be accessed directly.

However, sometimes you need more sophisticated policy and do not want to create a special function for that. In this case, alternative to new.name would be table.name where table is name of table you are writing policy for.

Faced this once, was not sure whether this behavior and workaround above was a bug or a feature.
Thanks to @alaister decided to double check and share.

insert-policy-new-variable.mp4