How to assign multiple variable and string in a variable in postgresql

Question

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

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

Are you looking for a simple concat()?, e.g.: var_string := concat(variable_1, ' ', variable_2, variable_3); Please edit your question and add some sample data and the expected output based on that data. Formatted text please, no screen shots. (do not post code or additional information in comments) — user330315
– user330315, Commented Jan 31, 2018 at 10:59

Bibin Mathew · Accepted Answer · 2018-01-31 11:03:55Z

1

Try CONCAT Function

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

answered Jan 31, 2018 at 11:03

Bibin Mathew

4653 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to assign multiple variable and string in a variable in postgresql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related