In postgresql return result of a function in a rule when performing INSERT INTO RETURNING
- by Dmitry
I have a View that has several fields.
When i INSERT INTO a view I run a function based on INSERT parametrs. The function returns a value.
How can I retrieve The value from rule?
INSERT RETURNING Gives me:
ERROR: cannot perform INSERT RETURNING on relation "full_subntes"
?????????: You need an unconditional ON INSERT DO INSTEAD rule with a…