如何在PostgreSQL中的变量中分配多个变量和字符串 [英] How to assign multiple variable and string in a variable in postgresql

问题描述

我想为postgresql变量分配多个值或字符串或它们的组合。
我想要实现的是在DB2中完成的操作：

I want to assign multiple values or string or their combination to a postgresql variable. What I want to achieve is something like this done in DB2:

STRING '('              DELIMITED BY SIZE           
       variable_1       DELIMITED BY SPACE          
       ' '              DELIMITED BY SIZE           
       variable_2                        
                        DELIMITED BY SIZE           
       variable_3       DELIMITED BY SIZE           
       ' ) '            DELIMITED BY SIZE           
       X'10'            DELIMITED BY SIZE           
     INTO    var_string                            
 END-STRING

同样，我有一些变量和字符串，我想在变量 var_string中添加。
有可能吗？

In the same way i have some variables and string which I want to add in a variable "var_string". Is it possible?

推荐答案

尝试使用CONCAT函数

Try CONCAT Function

 DECLARE var_string varchar;
 var_string:= concat(variable_1, variable_2,variable_3);

这篇关于如何在PostgreSQL中的变量中分配多个变量和字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！