How to assign values to more variables in a single statement?
I have a function which returns a table (actually a row from a table from the given primary key).
How to assign the columns returned by the function to more variables within a single statement?
I have the function: f(id int) returns table(col1, col2...coln).....
I want to call this function from a trigger:
???? = (select t.* from table(f(1)) as t)
What should I put instead of "????"
Should I use a structure? How?
Should I use a row function instead a table function?
I don't want to have the following code (although this code works):
set a_col1 = (select t.col1 from table(f(1)) as t); ......
set a_col2 = (select t.col2 from table(f(1)) as t); ......