Re: pgsql: Add pow(), aka power(), function to pgbench. - Mailing list pgsql-committers

From Fabien COELHO
Subject Re: pgsql: Add pow(), aka power(), function to pgbench.
Date
Msg-id alpine.DEB.2.20.1712291255350.14239@lancre
Whole thread Raw
In response to Re: pgsql: Add pow(), aka power(), function to pgbench.  (Thomas Munro <thomas.munro@enterprisedb.com>)
Responses Re: pgsql: Add pow(), aka power(), function to pgbench.  (Raúl Marín Rodríguez <rmrodriguez@carto.com>)
List pgsql-committers
> # debug(script=0,command=31): double 8.50705917302346e+037
> #     doesn't match '(?^:command=31.: double 8.50705917302346e\+37\b)'
>
> # debug(script=0,command=32): double 1e+030
> #     doesn't match '(?^:command=32.: double 1e\+30\b)'
>
> The difference seems to be a leading zero before the exponent, so
> perhaps the patterns need "0*" in there?

Probably "0?". Although an int with leading zeros is usually an octal 
number, so window's rational fails me.

-- 
Fabien.


pgsql-committers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: pgsql: Use new overflow aware integer operations.
Next
From: Raúl Marín Rodríguez
Date:
Subject: Re: pgsql: Add pow(), aka power(), function to pgbench.