title: COALESCE types character varying and numeric cannot be matched
body: <p>I have a table named <code>table1</code> with columns <code>Gender varchar(10)</code> and <code>Team numeric</code>.</p>
  
  <pre><code>create table table1 (
  ID integer
  Gender varchar(10),
  Team numeric
  );
  
  insert into table1 (ID,Gender,Team) values
  (1,'M',NULL),
  (2,NULL,10),
  (3,NULL,6),
  (4,''F',NULL),
  (5,NULL,3);
  </code></pre>
  
  <p>I will like to create a new column as <code>Nxt</code> that returns a row that is not null from any of the columns either a string or integer.</p>
  
  <p>The column <code>Nxt</code> will look like: <code>M,10,6,F,3</code></p>
  
  <p>I tried this:</p>
  
  <pre><code>select coalesce(Gender,Team) as value from table1;
  </code></pre>
  
  <p>It returns this error:</p>
  
  <blockquote>
    <p>COALESCE types character varying and numeric cannot be matched</p>
  </blockquote>