subject:"\[SQL\] Our FLOAT\(p\) precision does not conform to spec"

Re: [SQL] Our FLOAT(p) precision does not conform to spec

2003-06-16 Thread Richard Hall

Fix the problem and inform the users about code that may break. Rick ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[SQL] Our FLOAT(p) precision does not conform to spec

2003-06-16 Thread Tom Lane

Fernando Nasser of Red Hat pointed out to me that we are not quite spec-compliant on the FLOAT(p) datatype notation. We interpret P as the number of decimal digits of precision, and hence translate P = 1..6 => float4 (a/k/a REAL) P = 7..15 => float8 (a/k/a DOUBLE PRECISION)