agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedSQL error: function round(double precision, integer) does not exist
16+ messages / 10 participants
[nested] [flat]
* SQL error: function round(double precision, integer) does not exist
@ 2005-02-27 23:26 TJ O'Donnell <tjo@acm.org>
2005-02-28 09:12 ` Re: SQL error: function round(double precision, integer) does Richard Huxton <dev@archonet.com>
2005-02-28 09:12 ` Re: [despammed] SQL error: function round(double precision, integer) does not exist Andreas Kretschmer <akretschmer@despammed.com>
2005-02-28 10:43 ` Re: SQL error: function round(double precision, integer) does not exist Din Adrian <adrian.din@easynet.ro>
2005-02-28 13:37 ` Re: SQL error: function round(double precision, integer) does not Christoph Haller <ch@rodos.fzk.de>
2005-02-28 16:33 ` Re: SQL error: function round(double precision, integer) does not exist Michael Fuhr <mike@fuhr.org>
2005-02-28 17:30 ` Re: SQL error: function round(double precision, integer) does not exist Josh Berkus <josh@agliodbs.com>
0 siblings, 6 replies; 16+ messages in thread
From: TJ O'Donnell @ 2005-02-27 23:26 UTC (permalink / raw)
To: pgsql-sql
I received the following error when executing a SQL statement:
SQL error:
ERROR: function round(double precision, integer) does not exist
In statement:
select id,smiles,smarts,parameter,oe_count_matches(smiles,smarts) as count,
round((parameter*oe_count_matches(smiles,smarts)),2) as psa,tpsa(smiles) as ctpsa,tpsa
from structure,tpsa
where id < 237610
and oe_count_matches(smiles,smarts) > 0
order by id;
The functions described at:
http://www.postgresql.org/docs/7.4/static/functions-math.html
show that round(numeric,int) should work ok.
If I use round() without a second argument, it works OK, but
this gives a loss of precision which I do not want.
Can anyone help me with this?
Thanks,
TJ
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: SQL error: function round(double precision, integer) does
2005-02-27 23:26 SQL error: function round(double precision, integer) does not exist TJ O'Donnell <tjo@acm.org>
@ 2005-02-28 09:12 ` Richard Huxton <dev@archonet.com>
5 siblings, 0 replies; 16+ messages in thread
From: Richard Huxton @ 2005-02-28 09:12 UTC (permalink / raw)
To: tjo@acm.org; +Cc: pgsql-sql
TJ O'Donnell wrote:
> I received the following error when executing a SQL statement:
>
> SQL error:
> ERROR: function round(double precision, integer) does not exist
>
> In statement:
>
> select id,smiles,smarts,parameter,oe_count_matches(smiles,smarts) as count,
> round((parameter*oe_count_matches(smiles,smarts)),2) as
round((...)::numeric, 2)
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: [despammed] SQL error: function round(double precision, integer) does not exist
2005-02-27 23:26 SQL error: function round(double precision, integer) does not exist TJ O'Donnell <tjo@acm.org>
@ 2005-02-28 09:12 ` Andreas Kretschmer <akretschmer@despammed.com>
5 siblings, 0 replies; 16+ messages in thread
From: Andreas Kretschmer @ 2005-02-28 09:12 UTC (permalink / raw)
To: pgsql-sql
am 27.02.2005, um 15:26:07 -0800 mailte TJ O'Donnell folgendes:
> I received the following error when executing a SQL statement:
>
> SQL error:
> ERROR: function round(double precision, integer) does not exist
>
> In statement:
>
> select id,smiles,smarts,parameter,oe_count_matches(smiles,smarts) as
> count,
> round((parameter*oe_count_matches(smiles,smarts)),2) as
> psa,tpsa(smiles) as ctpsa,tpsa
> from structure,tpsa
> where id < 237610
> and oe_count_matches(smiles,smarts) > 0
try ... round((parameter*oe_count_matches(smiles,smarts))::numeric,2)
Regards, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: SQL error: function round(double precision, integer) does not exist
2005-02-27 23:26 SQL error: function round(double precision, integer) does not exist TJ O'Donnell <tjo@acm.org>
@ 2005-02-28 10:43 ` Din Adrian <adrian.din@easynet.ro>
5 siblings, 0 replies; 16+ messages in thread
From: Din Adrian @ 2005-02-28 10:43 UTC (permalink / raw)
To: tjo@acm.org; +Cc: pgsql-sql
the round sintax is
round(numeric,int)
not
round (double,int)
you must cast the value into numeric:
ex: round (cast(doublecolumn as numeric),2) should work ok
Adrian Din,
Om Computer & SoftWare
On Sun, 27 Feb 2005 15:26:07 -0800, TJ O'Donnell <tjo@acm.org> wrote:
> I received the following error when executing a SQL statement:
>
> SQL error:
> ERROR: function round(double precision, integer) does not exist
>
> In statement:
>
> select id,smiles,smarts,parameter,oe_count_matches(smiles,smarts) as
> count,
> round((parameter*oe_count_matches(smiles,smarts)),2) as
> psa,tpsa(smiles) as ctpsa,tpsa
> from structure,tpsa
> where id < 237610
> and oe_count_matches(smiles,smarts) > 0
>
> order by id;
>
> The functions described at:
> http://www.postgresql.org/docs/7.4/static/functions-math.html
> show that round(numeric,int) should work ok.
> If I use round() without a second argument, it works OK, but
> this gives a loss of precision which I do not want.
>
> Can anyone help me with this?
>
> Thanks,
> TJ
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: SQL error: function round(double precision, integer) does not
2005-02-27 23:26 SQL error: function round(double precision, integer) does not exist TJ O'Donnell <tjo@acm.org>
@ 2005-02-28 13:37 ` Christoph Haller <ch@rodos.fzk.de>
2005-02-28 14:40 ` Re: SQL error: function round(double precision, integer) does TJ O'Donnell <tjo@acm.org>
5 siblings, 1 reply; 16+ messages in thread
From: Christoph Haller @ 2005-02-28 13:37 UTC (permalink / raw)
To: tjo@acm.org; +Cc: pgsql-sql
TJ O'Donnell wrote:
>
> I received the following error when executing a SQL statement:
>
> SQL error:
> ERROR: function round(double precision, integer) does not exist
>
> In statement:
>
> select id,smiles,smarts,parameter,oe_count_matches(smiles,smarts) as count,
> round((parameter*oe_count_matches(smiles,smarts)),2) as psa,tpsa(smiles) as ctpsa,tpsa
> from structure,tpsa
> where id < 237610
> and oe_count_matches(smiles,smarts) > 0
>
> order by id;
>
> The functions described at:
> http://www.postgresql.org/docs/7.4/static/functions-math.html
> show that round(numeric,int) should work ok.
> If I use round() without a second argument, it works OK, but
> this gives a loss of precision which I do not want.
>
> Can anyone help me with this?
>
> Thanks,
> TJ
>
And round(numeric,int) does work ok.
The error message is telling you
there is double precision argument where a numeric
is expected.
And with 7.4.5 it says in addition
HINT: No function matches the given name and argument types.
You may need to add explicit type casts.
Try
round((parameter*oe_count_matches(smiles,smarts))::numeric,2)
Works for me with double precision arguments.
Regards, Christoph
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: SQL error: function round(double precision, integer) does
2005-02-27 23:26 SQL error: function round(double precision, integer) does not exist TJ O'Donnell <tjo@acm.org>
2005-02-28 13:37 ` Re: SQL error: function round(double precision, integer) does not Christoph Haller <ch@rodos.fzk.de>
@ 2005-02-28 14:40 ` TJ O'Donnell <tjo@acm.org>
0 siblings, 0 replies; 16+ messages in thread
From: TJ O'Donnell @ 2005-02-28 14:40 UTC (permalink / raw)
To: Christoph Haller <ch@rodos.fzk.de>; +Cc: pgsql-sql; adrian.din@easynet.ro; dev@archonet.com
Thanks everyone. Your tips about casting my arg to round()
as ::numeric worked just fine. I guess I was surprised
that plpgsql didn't that on it's own! I'm used to too
many forgiving c compilers, and such.
TJ
Christoph Haller wrote:
> TJ O'Donnell wrote:
>
>>I received the following error when executing a SQL statement:
>>
>>SQL error:
>>ERROR: function round(double precision, integer) does not exist
>>
>>In statement:
>>
>>select id,smiles,smarts,parameter,oe_count_matches(smiles,smarts) as count,
>> round((parameter*oe_count_matches(smiles,smarts)),2) as psa,tpsa(smiles) as ctpsa,tpsa
>> from structure,tpsa
>> where id < 237610
>> and oe_count_matches(smiles,smarts) > 0
>>
>>order by id;
>>
>>The functions described at:
>>http://www.postgresql.org/docs/7.4/static/functions-math.html
>>show that round(numeric,int) should work ok.
>>If I use round() without a second argument, it works OK, but
>>this gives a loss of precision which I do not want.
>>
>>Can anyone help me with this?
>>
>>Thanks,
>>TJ
>>
>
>
> And round(numeric,int) does work ok.
> The error message is telling you
> there is double precision argument where a numeric
> is expected.
> And with 7.4.5 it says in addition
> HINT: No function matches the given name and argument types.
> You may need to add explicit type casts.
>
> Try
> round((parameter*oe_count_matches(smiles,smarts))::numeric,2)
>
> Works for me with double precision arguments.
>
> Regards, Christoph
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: SQL error: function round(double precision, integer) does not exist
2005-02-27 23:26 SQL error: function round(double precision, integer) does not exist TJ O'Donnell <tjo@acm.org>
@ 2005-02-28 16:33 ` Michael Fuhr <mike@fuhr.org>
2005-02-28 17:12 ` Re: SQL error: function round(double precision, integer) does TJ O'Donnell <tjo@acm.org>
5 siblings, 1 reply; 16+ messages in thread
From: Michael Fuhr @ 2005-02-28 16:33 UTC (permalink / raw)
To: TJ O'Donnell <tjo@acm.org>; +Cc: pgsql-sql
On Sun, Feb 27, 2005 at 03:26:07PM -0800, TJ O'Donnell wrote:
> ERROR: function round(double precision, integer) does not exist
^^^^^^^^^^^^^^^^
[snip]
> The functions described at:
> http://www.postgresql.org/docs/7.4/static/functions-math.html
> show that round(numeric,int) should work ok.
^^^^^^^
The two-argument form of round() expects the first argument to be
numeric, not double precision. There's no implicit cast from double
precision to numeric, so you'll have to use an explicit cast:
SELECT ... round((expression)::numeric, 2) ...
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: SQL error: function round(double precision, integer) does
2005-02-27 23:26 SQL error: function round(double precision, integer) does not exist TJ O'Donnell <tjo@acm.org>
2005-02-28 16:33 ` Re: SQL error: function round(double precision, integer) does not exist Michael Fuhr <mike@fuhr.org>
@ 2005-02-28 17:12 ` TJ O'Donnell <tjo@acm.org>
2005-02-28 21:54 ` Re: SQL error: function round(double precision, integer) does Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 16+ messages in thread
From: TJ O'Donnell @ 2005-02-28 17:12 UTC (permalink / raw)
To: Michael Fuhr <mike@fuhr.org>; +Cc: pgsql-sql
I got round(numeric,int) working OK, but it's got me thinking (a dangerous thing!).
Is there some fundamental reason for round(dp) but round(numeric,int)?
Shouldn't they be, at least, consistent, having round(numeric)
or round(dp,int)?
Am I missing something?
Thanks,
TJ
Michael Fuhr wrote:
> On Sun, Feb 27, 2005 at 03:26:07PM -0800, TJ O'Donnell wrote:
>
>
>>ERROR: function round(double precision, integer) does not exist
>
> ^^^^^^^^^^^^^^^^
> [snip]
>
>
>>The functions described at:
>>http://www.postgresql.org/docs/7.4/static/functions-math.html
>>show that round(numeric,int) should work ok.
>
> ^^^^^^^
>
> The two-argument form of round() expects the first argument to be
> numeric, not double precision. There's no implicit cast from double
> precision to numeric, so you'll have to use an explicit cast:
>
> SELECT ... round((expression)::numeric, 2) ...
>
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: SQL error: function round(double precision, integer) does
2005-02-27 23:26 SQL error: function round(double precision, integer) does not exist TJ O'Donnell <tjo@acm.org>
2005-02-28 16:33 ` Re: SQL error: function round(double precision, integer) does not exist Michael Fuhr <mike@fuhr.org>
2005-02-28 17:12 ` Re: SQL error: function round(double precision, integer) does TJ O'Donnell <tjo@acm.org>
@ 2005-02-28 21:54 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 16+ messages in thread
From: Tom Lane @ 2005-02-28 21:54 UTC (permalink / raw)
To: tjo@acm.org; +Cc: Michael Fuhr <mike@fuhr.org>; pgsql-sql
"TJ O'Donnell" <tjo@acm.org> writes:
> Is there some fundamental reason for round(dp) but round(numeric,int)?
I think the main argument against supporting round(dp,int) is that the
result would be inherently inexact (at least for int>0).
regards, tom lane
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: SQL error: function round(double precision, integer) does not exist
2005-02-27 23:26 SQL error: function round(double precision, integer) does not exist TJ O'Donnell <tjo@acm.org>
@ 2005-02-28 17:30 ` Josh Berkus <josh@agliodbs.com>
5 siblings, 0 replies; 16+ messages in thread
From: Josh Berkus @ 2005-02-28 17:30 UTC (permalink / raw)
To: tjo@acm.org; +Cc: pgsql-sql
TJ,
> SQL error:
> ERROR: function round(double precision, integer) does not exist
> http://www.postgresql.org/docs/7.4/static/functions-math.html
> show that round(numeric,int) should work ok.
> If I use round() without a second argument, it works OK, but
> this gives a loss of precision which I do not want.
NUMERIC and FLOAT are different data types. Do:
round({value}::NUMERIC, {places})
--
Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: SQL error: function round(double precision, integer) does not exist
@ 2017-05-25 17:26 Vladimir Nicolici <vladnc@gmail.com>
2017-05-25 17:54 ` Re: Re: SQL error: function round(double precision, integer) does not exist Tom Lane <tgl@sss.pgh.pa.us>
2017-05-25 17:56 ` Re: Re: SQL error: function round(double precision, integer) does not exist David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 2 replies; 16+ messages in thread
From: Vladimir Nicolici @ 2017-05-25 17:26 UTC (permalink / raw)
To: pgsql-sql
Any plans to fix this annoyance?
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: Re: SQL error: function round(double precision, integer) does not exist
2017-05-25 17:26 Re: SQL error: function round(double precision, integer) does not exist Vladimir Nicolici <vladnc@gmail.com>
@ 2017-05-25 17:54 ` Tom Lane <tgl@sss.pgh.pa.us>
2017-05-25 17:55 ` Re: Re: SQL error: function round(double precision, integer) does not exist Vladimir Nicolici <vladnc@gmail.com>
1 sibling, 1 reply; 16+ messages in thread
From: Tom Lane @ 2017-05-25 17:54 UTC (permalink / raw)
To: Vladimir Nicolici <vladnc@gmail.com>; +Cc: pgsql-sql
Vladimir Nicolici <vladnc@gmail.com> writes:
> Any plans to fix this annoyance?
Not particularly. Making round() work with floats seems questionable,
since the result frequently couldn't be represented exactly, making the
whole exercise a bit pointless. Why don't you cast the float to numeric?
regards, tom lane
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: Re: SQL error: function round(double precision, integer) does not exist
2017-05-25 17:26 Re: SQL error: function round(double precision, integer) does not exist Vladimir Nicolici <vladnc@gmail.com>
2017-05-25 17:54 ` Re: Re: SQL error: function round(double precision, integer) does not exist Tom Lane <tgl@sss.pgh.pa.us>
@ 2017-05-25 17:55 ` Vladimir Nicolici <vladnc@gmail.com>
2017-05-25 18:22 ` Re: Re: SQL error: function round(double precision, integer) does not exist Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 16+ messages in thread
From: Vladimir Nicolici @ 2017-05-25 17:55 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
I do that, but it’s extremely annoying.
Every time I hit this issue it looks to me like a PostgreSQL bug that I need to workaround for. Especially since other database products make this conversion automatically, and I have built muscle memory for that.
Furthermore, since the single parameter version accepts double precision numbers, the imprecise representation excuse seems questionable at best.
Anyway, I’ll try to use the double precision data type as little as possible, since it causes these annoyances.
@David, I’m aware it’s been 12 years since the original post.
From: Tom Lane<mailto:tgl@sss.pgh.pa.us>
Sent: Thursday, May 25, 2017 20:54
To: Vladimir Nicolici<mailto:vladnc@gmail.com>
Cc: pgsql-sql@postgresql.org<mailto:pgsql-sql@postgresql.org>
Subject: Re: [SQL] Re: SQL error: function round(double precision, integer) does not exist
Vladimir Nicolici <vladnc@gmail.com> writes:
> Any plans to fix this annoyance?
Not particularly. Making round() work with floats seems questionable,
since the result frequently couldn't be represented exactly, making the
whole exercise a bit pointless. Why don't you cast the float to numeric?
regards, tom lane
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: Re: SQL error: function round(double precision, integer) does not exist
2017-05-25 17:26 Re: SQL error: function round(double precision, integer) does not exist Vladimir Nicolici <vladnc@gmail.com>
2017-05-25 17:54 ` Re: Re: SQL error: function round(double precision, integer) does not exist Tom Lane <tgl@sss.pgh.pa.us>
2017-05-25 17:55 ` Re: Re: SQL error: function round(double precision, integer) does not exist Vladimir Nicolici <vladnc@gmail.com>
@ 2017-05-25 18:22 ` Tom Lane <tgl@sss.pgh.pa.us>
2017-05-25 18:23 ` Re: Re: SQL error: function round(double precision, integer) does not exist Vladimir Nicolici <vladnc@gmail.com>
0 siblings, 1 reply; 16+ messages in thread
From: Tom Lane @ 2017-05-25 18:22 UTC (permalink / raw)
To: Vladimir Nicolici <vladnc@gmail.com>; +Cc: pgsql-sql
Vladimir Nicolici <vladnc@gmail.com> writes:
> I do that, but its extremely annoying.
Well, if it rises to the level of extreme annoyance for you, there
is a simple solution:
create function round(float8, int) returns numeric as
'select round($1::numeric, $2)' language sql;
> Furthermore, since the single parameter version accepts double precision numbers, the imprecise representation excuse seems questionable at best.
The single-parameter version always rounds to integer, which avoids the
problem of not being able to represent decimal fractions exactly.
regards, tom lane
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: Re: SQL error: function round(double precision, integer) does not exist
2017-05-25 17:26 Re: SQL error: function round(double precision, integer) does not exist Vladimir Nicolici <vladnc@gmail.com>
2017-05-25 17:54 ` Re: Re: SQL error: function round(double precision, integer) does not exist Tom Lane <tgl@sss.pgh.pa.us>
2017-05-25 17:55 ` Re: Re: SQL error: function round(double precision, integer) does not exist Vladimir Nicolici <vladnc@gmail.com>
2017-05-25 18:22 ` Re: Re: SQL error: function round(double precision, integer) does not exist Tom Lane <tgl@sss.pgh.pa.us>
@ 2017-05-25 18:23 ` Vladimir Nicolici <vladnc@gmail.com>
0 siblings, 0 replies; 16+ messages in thread
From: Vladimir Nicolici @ 2017-05-25 18:23 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
In my opinion the integer version doesn’t prevent the fraction problem at all, since the rounding works on fractions, even when the result is an integer. In fact it seems to introduce what I would consider a bug, compared to doing the conversion explicitly, for example in this query:
select round(0.5::real), round(0.5::double precision), round((0.5::double precision)::numeric), round(0.5)
The result will be 0, 0, 1, 1, which is very strange.
I think, at the very least, the implicit and explicit conversions, -- round(0.5::double precision) and round((0.5::double precision)::numeric) -- should give the same result, and they don’t. Which reinforces my intuition that I should avoid the real and double precision data types whenever possible.
Thanks,
Vlad
From: Tom Lane<mailto:tgl@sss.pgh.pa.us>
Sent: Thursday, May 25, 2017 21:22
To: Vladimir Nicolici<mailto:vladnc@gmail.com>
Cc: pgsql-sql@postgresql.org<mailto:pgsql-sql@postgresql.org>
Subject: Re: [SQL] Re: SQL error: function round(double precision, integer) does not exist
Vladimir Nicolici <vladnc@gmail.com> writes:
> I do that, but itÂ’s extremely annoying.
Well, if it rises to the level of extreme annoyance for you, there
is a simple solution:
create function round(float8, int) returns numeric as
'select round($1::numeric, $2)' language sql;
> Furthermore, since the single parameter version accepts double precision numbers, the imprecise representation excuse seems questionable at best.
The single-parameter version always rounds to integer, which avoids the
problem of not being able to represent decimal fractions exactly.
regards, tom lane
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: Re: SQL error: function round(double precision, integer) does not exist
2017-05-25 17:26 Re: SQL error: function round(double precision, integer) does not exist Vladimir Nicolici <vladnc@gmail.com>
@ 2017-05-25 17:56 ` David G. Johnston <david.g.johnston@gmail.com>
1 sibling, 0 replies; 16+ messages in thread
From: David G. Johnston @ 2017-05-25 17:56 UTC (permalink / raw)
To: Vladimir Nicolici <vladnc@gmail.com>; +Cc: pgsql-sql
On Thursday, May 25, 2017, Vladimir Nicolici <vladnc@gmail.com> wrote:
>
> Any plans to fix this annoyance?
>
It's been over 12 years since the thread you are replying to was active...
https://www.postgresql.org/message-id/flat/4222570F.5080901%40acm.org#4222570F.5080901@acm.org
David J.
^ permalink raw reply [nested|flat] 16+ messages in thread
end of thread, other threads:[~2017-05-25 18:23 UTC | newest]
Thread overview: 16+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-27 23:26 SQL error: function round(double precision, integer) does not exist TJ O'Donnell <tjo@acm.org>
2005-02-28 09:12 ` Re: SQL error: function round(double precision, integer) does Richard Huxton <dev@archonet.com>
2005-02-28 09:12 ` Andreas Kretschmer <akretschmer@despammed.com>
2005-02-28 10:43 ` Din Adrian <adrian.din@easynet.ro>
2005-02-28 13:37 ` Re: SQL error: function round(double precision, integer) does not Christoph Haller <ch@rodos.fzk.de>
2005-02-28 14:40 ` Re: SQL error: function round(double precision, integer) does TJ O'Donnell <tjo@acm.org>
2005-02-28 16:33 ` Michael Fuhr <mike@fuhr.org>
2005-02-28 17:12 ` Re: SQL error: function round(double precision, integer) does TJ O'Donnell <tjo@acm.org>
2005-02-28 21:54 ` Re: SQL error: function round(double precision, integer) does Tom Lane <tgl@sss.pgh.pa.us>
2005-02-28 17:30 ` Josh Berkus <josh@agliodbs.com>
2017-05-25 17:26 Re: SQL error: function round(double precision, integer) does not exist Vladimir Nicolici <vladnc@gmail.com>
2017-05-25 17:54 ` Tom Lane <tgl@sss.pgh.pa.us>
2017-05-25 17:55 ` Vladimir Nicolici <vladnc@gmail.com>
2017-05-25 18:22 ` Tom Lane <tgl@sss.pgh.pa.us>
2017-05-25 18:23 ` Vladimir Nicolici <vladnc@gmail.com>
2017-05-25 17:56 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox