title: PostgreSQL - return n-sized varchar from function
body: <p>As I found in documentation: </p>
  
  <blockquote>
    <p>Parenthesized type modifiers (e.g., the precision field for type
    numeric) are discarded by CREATE FUNCTION</p>
  </blockquote>
  
  <p>Are there any alternatives to return varchar(N) type from plpgsql function?</p>
  
  <hr>
  
  <p><strong>question update:</strong></p>
  
  <p>On picture you can see that Name column recognised as varchar(128), however Number column is recognised as nonsized varchar</p>
  
  <p><a href="https://i.stack.imgur.com/eKkeN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eKkeN.png" alt="Result example"></a></p>
  
  <p>f_concat function returns: cast(res as varchar(255));</p>