title: plpgsql: How can we give "max" value to varchar data type?
body: <p>For example:
  Suppose i want to use a string which should be maximum in numbers, so can i use "varchar(max)" in my query? 
  Here "max" is not an aggregate function. It's a maximum number of characters.</p>
  
  <p>Example:</p>
  
  <pre><code>declare
         name varchar(20);
         details varchar(max); --Its not working in plpgsql.
  </code></pre>