Re: BUG #13504: Types in math functions table is incorrect - Mailing list pgsql-bugs

From Tobias Pfeiffer
Subject Re: BUG #13504: Types in math functions table is incorrect
Date
Msg-id 20150718141131.2e03be9a@samsux
Whole thread Raw
In response to Re: BUG #13504: Types in math functions table is incorrect  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Hi,

On Fri, 17 Jul 2015 12:24:51 -0400 Tom Lane wrote:
> "David G. Johnston" <david.g.johnston@gmail.com> writes:
> > On Thursday, July 16, 2015, <tgpfeiffer@web.de> wrote:
> >> I have not checked all of the functions in that table, but at
> >> least the ones above need to be fixed, I think.
>=20
> > It would be helpful if you supplied the queries you used to make
> > these determinations.
>=20
> I think the OP is misreading the table and/or failing to note the
> statement above it: "Many of these functions are provided in multiple
> forms with different argument types. Except where noted, any given
> form of a function returns the same data type as its argument."

Ah, yes, that's exactly what happened...

> [...]
> What the table does *not* say is "ln of any random numeric-category
> datatype returns that same type".=20

That's what I read out of it, I was somehow assuming "numeric"
describes a "random numeric-category". Sorry, my mistake.

Kind regards,
Tobias

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #12379: pgbench should hint to pgbench -i
Next
From: Michael Bommarito
Date:
Subject: Re: BUG #13490: Segmentation fault on pg_stat_activity