Pgsql Variable Assignment method

1, online generally said the method is as follows:

: =, assignment, e.g. user_id: = 20;

Select into assignment, such as SELECT INTO Myrec * from emp WHERE empname = myname

2, I present today is a more general and more practical assignment method

Select ... into ...

Examples of Use:

A variable, select INTO user_id;

Multiple variables, select 20,30,50 into A,B.C;

3, in the storage function (that is, in the stored procedure) and into is also very common.

For example, when stitching characters, go directly into.

Select ' Update student set remark = ' ' | | Now () | | ' where student.id = ' | | $ into sql_str_run;
Execute Sql_str_run;

Pgsql Variable Assignment method