From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Glen Parker" <glenebob(at)nwlink(dot)com> |
Cc: | "Pg-General" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: ERROR: function round(double precision, integer) does not exist - WTF? |
Date: | 2004-03-05 02:35:57 |
Message-ID: | D90A5A6C612A39408103E6ECDD77B8299CA858@voyager.corporate.connx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Thursday, March 04, 2004 6:18 PM
> To: Glen Parker
> Cc: Pg-General
> Subject: Re: [GENERAL] ERROR: function round(double
> precision, integer) does not exist - WTF?
>
>
> "Glen Parker" <glenebob(at)nwlink(dot)com> writes:
> > DB=# select round(1.25::float, 2);
> > ERROR: function round(double precision, integer) does not exist
>
> > What the heck? This can't be right... Can it?
>
> regression=# \df round
> List of functions
> Result data type | Schema | Name | Argument data types
> ------------------+------------+-------+---------------------
> double precision | pg_catalog | round | double precision
> numeric | pg_catalog | round | numeric
> numeric | pg_catalog | round | numeric, integer
> (3 rows)
>
> Looks right to me: the only 2-arg flavor of round() is on
> numeric, not float8.
>
> You could always cast the float to numeric, of course. I
> think in 7.2 such conversions were allowed silently, but we
> have reduced the number of implicit type coercions.
Why?
From | Date | Subject | |
---|---|---|---|
Next Message | Karl O. Pinc | 2004-03-05 02:39:04 | Re: REFERENCES error message complaint, suggestion |
Previous Message | Tom Lane | 2004-03-05 02:18:23 | Re: ERROR: function round(double precision, integer) does not exist - WTF? |