Re: pgsql: Add pow(), aka power(), function to pgbench.

2017-12-29 Thread Andrew Dunstan
On 12/29/2017 08:04 AM, Raúl Marín Rodríguez wrote: > > Probably "0?". Although an int with leading zeros is usually an > octal number, so window's rational fails me. > > > You are right. From the C99 standard: > > The exponent always contains at least two digits, and only as many >

Re: pgsql: Add pow(), aka power(), function to pgbench.

2017-12-29 Thread Raúl Marín Rodríguez
> > Probably "0?". Although an int with leading zeros is usually an octal > number, so window's rational fails me. You are right. From the C99 standard: > The exponent always contains at least two digits, and only as many more > digits as necessary to represent the exponent. If the value is zero

Re: pgsql: Add pow(), aka power(), function to pgbench.

2017-12-29 Thread Fabien COELHO
# 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, s

Re: pgsql: Add pow(), aka power(), function to pgbench.

2017-12-29 Thread Thomas Munro
On Thu, Dec 28, 2017 at 7:47 AM, Robert Haas wrote: > Add pow(), aka power(), function to pgbench. > > Raúl Marín Rodríguez, reviewed by Fabien Coelho and Michael Paquier, > with a minor fix by me. > > Discussion: > http://postgr.es/m/cam6_um4xia14y9hndqu9kaaotwmhhzxw--q_zaczw9hsrsf...@mail.gmail

pgsql: Add pow(), aka power(), function to pgbench.

2017-12-27 Thread Robert Haas
Add pow(), aka power(), function to pgbench. Raúl Marín Rodríguez, reviewed by Fabien Coelho and Michael Paquier, with a minor fix by me. Discussion: http://postgr.es/m/cam6_um4xia14y9hndqu9kaaotwmhhzxw--q_zaczw9hsrsf...@mail.gmail.com Branch -- master Details --- https://git.postgresq