ERROR: function round(double precision, integer) does not exist - WTF?

Поиск
Список
Период
Сортировка
Искать
От
Glen Parker
Тема
ERROR: function round(double precision, integer) does not exist - WTF?
Дата
Msg-id
000901c4024e$63bbe760$0b01a8c0@saturn
Ответ на
Список
Дерево обсуждения
REFERENCES error message complaint, suggestion "Karl O. Pinc" <kop@meme.com>
Re: REFERENCES error message complaint, suggestion Tom Lane <tgl@sss.pgh.pa.us>
Re: REFERENCES error message complaint, suggestion "Karl O. Pinc" <kop@meme.com>
Re: REFERENCES error message complaint, suggestion Tom Lane <tgl@sss.pgh.pa.us>
Re: REFERENCES error message complaint, suggestion "Karl O. Pinc" <kop@meme.com>
Re: REFERENCES error message complaint, suggestion Tom Lane <tgl@sss.pgh.pa.us>
Re: REFERENCES error message complaint, suggestion Enrico Weigelt <weigelt@metux.de>
Re: REFERENCES error message complaint, suggestion Bruce Momjian <pgman@candle.pha.pa.us>
Re: REFERENCES error message complaint, suggestion Tom Lane <tgl@sss.pgh.pa.us>
Re: REFERENCES error message complaint, suggestion "Rod K" <rod@23net.net>
Re: REFERENCES error message complaint, suggestion "Uwe C. Schroeder" <uwe@oss4u.com>
Re: REFERENCES error message complaint, suggestion Greg Stark <gsstark@mit.edu>
ERROR: function round(double precision, integer) does not exist - WTF? "Glen Parker" <glenebob@nwlink.com>
Re: ERROR: function round(double precision, integer) does not exist - WTF? Tom Lane <tgl@sss.pgh.pa.us>
Re: ERROR: function round(double precision, integer) does "Joshua D. Drake" <jd@commandprompt.com>
Re: ERROR: function round(double precision, integer) does "Glen Parker" <glenebob@nwlink.com>
Re: ERROR: function round(double precision, integer) does Andrew Sullivan <ajs@crankycanuck.ca>
Re: ERROR: function round(double precision, integer) does Tom Lane <tgl@sss.pgh.pa.us>
Re: REFERENCES error message complaint, suggestion Greg Stark <gsstark@mit.edu>
Re: REFERENCES error message complaint, suggestion "Karl O. Pinc" <kop@meme.com>
I'm having trouble with the round() function.  What I am trying to do works
fine on 7.2.*, but not in 7.3.* or 7.4.*

DB=# select version();
PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2
20031107 (Red Hat Linux 3.3.2-2)

DB=# select round(1.25::float);
 round 
-------
     1
(1 row)

oms=# select round(1.25::decimal, 2);
 round 
-------
  1.25
(1 row)

BUT.............

DB=# select round(1.25::float, 2);
ERROR:  function round(double precision, integer) does not exist
HINT:  No function matches the given name and argument types. You may need
to add explicit type casts.


What the heck?  This can't be right... Can it?

Thx!
Glen Parker
glenebob@nwlink.com



В списке pgsql-general по дате отправления
От: DeJuan Jackson
Дата:
Сообщение: Tom Lane heads up
От: Joshua D. Drake
Дата:
FAQ