On Fri, Aug 20, 2021 at 8:51 AM Roger Mason <rmason(at)mun(dot)ca> wrote:
> select into info_table from (select get_info('1043_1')) as info_split;
>
I suggest you should pretend that SQL's "SELECT INTO" doesn't exist. If
you want to create a table from a result write: "CREATE TABLE AS" and then
a normal select query. In particular the entire "action" command is kept
whole instead of needing to put a bunch of column names in between the
"SELECT" and the "INTO" - and you also are less likely to confuse the
plpgsql feature of the same form.
David J.