title: Concatenate string in statement that assigns a variable in PostgreSQL
body: <p>I am trying to convert SQL Server procedure to PostgreSQL.</p>
  
  <p>In the SQL Server procedure There are statements like below</p>
  
  <blockquote>
    <p>SET @val = '(' + @someval + ')'</p>
  </blockquote>
  
  <p>So in postgresql I wrote as below</p>
  
  <blockquote>
    <p>SET val = '(' || someval || ')';</p>
  </blockquote>
  
  <p>But the above statement giving error at ||</p>
  
  <p>Any body can please tell me where am I making mistake</p>