title: Type double does not exist in PostgreSQL
body: <p>I have table like this:</p>
  
  <pre><code>CREATE TABLE workingtime_times
  (
    workingno serial NOT NULL,
    checktime character(6) NOT NULL,
    timeoffset double precision DEFAULT 9
  )
  </code></pre>
  
  <p>I create function like this:</p>
  
  <pre><code>CREATE OR REPLACE FUNCTION MyFName()
      RETURNS TABLE(
          CheckTime character varying,
          TimeOffset double 
      ) AS
  $BODY$
  BEGIN 
      RETURN QUERY 
      SELECT  t.CheckTime, t.TimeOffset
      FROM WorkingTime_Times t
      ORDER BY t.WorkingNo DESC
      limit 1;
  END;
  $BODY$
    LANGUAGE plpgsql VOLATILE
    COST 100
    ROWS 1000;
  ALTER FUNCTION MyFName()
    OWNER TO postgres;
  </code></pre>
  
  <p>It make an error like this: </p>
  
  <blockquote>
    <p>type double does not exist</p>
  </blockquote>
  
  <p>Why we can create an table with column datatype double but return in the function fail. What type we can return in this case?</p>