title: POSTGRESQL array not always returning first NULL element
body: <p>I have a column in a table, with character varying[] type:</p>
  <pre><code>select details from x where id = 1;
  
  Results:
  [2:10]={wfeweqf,NULL,NULL,wefwf,NULL,NULL,NULL,NULL,wqfewef}
  </code></pre>
  <p>which means that detail<a href="https://i.stack.imgur.com/LlWjj.png" rel="nofollow noreferrer">1</a> is null:</p>
  <pre><code>select details[1] from x where id = 1;
      
  Results:
  [null]
  </code></pre>
  <p>Is there a way to access all elements of this array, to get:</p>
  <pre><code>Results:
  {NULL,wfeweqf,NULL,NULL,wefwf,NULL,NULL,NULL,NULL,wqfewef}
  </code></pre>
  <p>?</p>
  <p>I guess is not the purpose of this mechanism of omitting first nulls in array, but unfortunetly I need whole array.</p>
  <h1>edit:</h1>
  <hr />
  <h2><a href="https://i.stack.imgur.com/LlWjj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LlWjj.png" alt="details" /></a></h2>
  <h2><a href="https://i.stack.imgur.com/ZDy2B.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZDy2B.png" alt="details1" /></a></h2>
  <h2><a href="https://i.stack.imgur.com/7BxmZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7BxmZ.png" alt="unnest" /></a></h2>
  <p><a href="https://i.stack.imgur.com/aP4ql.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aP4ql.png" alt="len" /></a></p>