Re: Moving from TSQL to PL/pgsql select into a variable... - Mailing list pgsql-sql

n Mon, Mar 18, 2019 at 7:53 AM Ron Clarke <rclarkeai@gmail.com> wrote:
> SELECT cast('a' as varchar) AS X INTO myvar;

That is correct though you'll more often see:

myvar := SELECT cast('1' as varchar);

>     SELECT myvar;

That is the SELECT statement that doesn't have a result.

David J.