title: Array of arrays in PostgreSQL
body: <p>I'm using the %% operator on PostgreSQL's <code>hstore</code> type which converts a hstore (key-value type effectively) into an array whose elements alternate {{key, value}, {key value}}.</p>
  
  <p>When I want to return array of these flattened hstores I get this error: <code>could not find array type for data type text[]</code>due to PostgreSQL lack of support for an array of arrays.</p>
  
  <p>From a curiosity standpoint, does anyone know why these are not supported? And more importantly, is there a work around for this type of scenario?</p>
  
  <p>At the moment I'm concatenating the results into a string (comma separated) and parsing them on the application (C# and NPGSQL) side. However, this approach doesn't feel quite right, I'd like to be able to read the row back as a .NET array of arrays or array of key-values etc.</p>
  
  <p>Many thanks.</p>