Re: plpgsql select into

From: Roger Mason <rmason(at)mun(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: plpgsql select into
Date: 2021-08-21 10:52:28
Message-ID: y651r6nqdcj.fsf@mun.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Tom Lane writes:

> Roger Mason <rmason(at)mun(dot)ca> writes:
> You selected zero columns (which psql is not very good at displaying :-().
> Try
>
> select * into info_table from (select get_info('1043_1')) as info_split;
>
> BTW, that could be simplified a lot:
>
> select * into info_table from get_info('1043_1');

Embarassed cough :-).

And thanks for the simplification.

Roger

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Roger Mason 2021-08-21 10:54:21 Re: plpgsql select into
Previous Message David G. Johnston 2021-08-20 16:12:03 Re: plpgsql select into