title: Convert multiple rows into one row with multiple columns
body: <p>I've a table containing information as follows:</p>
  
  <pre><code>idnumber     applic_id      cctype     ccnumber
  ---------  ------------    --------   ----------
      1           23            1         223445
      2           23            2         345567
  </code></pre>
  
  <p>I need a query that an make this:</p>
  
  <pre><code>idnumber     applic_id      cctype     ccnumber  idnumber     applic_id      cctype     ccnumber
  ---------  ------------    --------   ----------  ---------  ------------    --------   ----------
      1           23            1         223445       2           23            2         345567 
  </code></pre>
  
  <p>Is anyone have a clue? I'm using PostgreSQL 8.3.</p>