Re: Moving from TSQL to PL/pgsql select into a variable...

"David G. Johnston" <[email protected]> Mon, 18 Mar 2019 07:57:46 -0700

Newsgroups	gmane.comp.db.postgresql.sql
Message-ID	<CAKFQuwbYpWDjDYmE0fjrp8OTgRxNULaZYKMh3P-WDu3T8yGUuA@mail.gmail.com>

n Mon, Mar 18, 2019 at 7:53 AM Ron Clarke <[email protected]> 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.