Selecting reals into doubles

From: Will Newton <will(at)gbdirect(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Selecting reals into doubles
Date: 2004-03-03 11:19:15
Message-ID: 20040303111915.GA16209@gbdirect.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I have attached some SQL which produces what to me, at least, is
rather unexpected results. Selecting real columns into double
precision columns loses some precision. Is this expected or documented
anywhere?

Thanks,

Attachment Content-Type Size
precision.sql text/plain 353 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Colin Fox 2004-03-03 12:22:17 Re: plpgsql trigger function with arguments
Previous Message scrappy 2004-03-03 10:16:37 :)