Re: BUG #13504: Types in math functions table is incorrect

From: Tobias Pfeiffer <tgpfeiffer(at)web(dot)de>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #13504: Types in math functions table is incorrect
Date: 2015-07-18 05:11:31
Message-ID: 20150718141131.2e03be9a@samsux
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

On Fri, 17 Jul 2015 12:24:51 -0400 Tom Lane wrote:
> "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> > On Thursday, July 16, 2015, <tgpfeiffer(at)web(dot)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.
>
> > It would be helpful if you supplied the queries you used to make
> > these determinations.
>
> 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".

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

Kind regards,
Tobias

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Julien Rouhaud 2015-07-18 11:05:04 Re: BUG #12379: pgbench should hint to pgbench -i
Previous Message Andrew Gierth 2015-07-17 18:57:22 Re: Grouping Sets: Fix unrecognized node type bug