title: Postgres - split TSTZRANGE in two columns
body: <p>I'm using PostgreSQL 9.4
  I have column in a table named <code>timerange</code> and want to write a <code>SELECT</code> query which will return time range in two separate columns <code>time_start</code> and <code>time_end</code>.
  I tried to handle this like an array but it doesn't work:</p>
  <pre><code>select *, timerange[0] as t_start from schedules;
  </code></pre>
  <p>Current table:</p>
  <pre class="lang-none prettyprint-override"><code>| id |                    timerange                        |  
  |----|-----------------------------------------------------|  
  | 1  | [&quot;2017-05-05 19:00:00+02&quot;,&quot;2017-05-05 21:00:00+02&quot;) |  
  | 2  | [&quot;2017-05-05 19:00:00+02&quot;,&quot;2017-05-05 21:00:00+02&quot;) |  
  </code></pre>
  <p>Desired table:</p>
  <pre class="lang-none prettyprint-override"><code>| id |        time_start        |       time_end           | 
  |----|--------------------------|--------------------------|
  | 1  | &quot;2017-05-05 19:00:00+02&quot; | &quot;2017-05-05 21:00:00+02&quot; |  
  | 2  | &quot;2017-05-05 19:00:00+02&quot; | &quot;2017-05-05 21:00:00+02&quot; |  
  </code></pre>