Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Committers > Re: pgsql: Have...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 5 of 11 Topic 16074 of 17642
Post > Topic >>

Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather

by bruce@[EMAIL PROTECTED] (Bruce Momjian) May 8, 2008 at 06:34 PM

Tom Lane wrote:
> momjian@[EMAIL PROTECTED]
 (Bruce Momjian) writes:
> > Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^ 0.0
> > return 1, rather than error.
> 
> This is wrongly described, and the implementation is still not correct
> either, because it should throw an error for negative exponents.
> Would you please *read* that wikipedia page you keep citing?
> http://en.wikipedia.org/wiki/Exponentiation#Powers_of_zero

I think this is fixed in the version I just committed:

	test=> select 0 ^ (-1);
	ERROR:  invalid argument for power function
	test=> select 0 ^ (-1.0);
	ERROR:  invalid argument for power function

-- 
  Bruce Momjian  <bruce@[EMAIL PROTECTED]
>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

-- 
Sent via pgsql-committers mailing list (pgsql-committers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers
 




 11 Posts in Topic:
pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error, and
momjian@[EMAIL PROTECTED]  2008-05-08 19:25:38 
Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather than
neilc@[EMAIL PROTECTED]   2008-05-08 14:00:35 
Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather
bruce@[EMAIL PROTECTED]   2008-05-08 18:18:00 
Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error,
tgl@[EMAIL PROTECTED] (T  2008-05-08 18:23:31 
Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather
bruce@[EMAIL PROTECTED]   2008-05-08 18:34:20 
Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather than
simon@[EMAIL PROTECTED]   2008-05-09 09:00:36 
Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error,
tgl@[EMAIL PROTECTED] (T  2008-05-09 10:37:07 
Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather
bruce@[EMAIL PROTECTED]   2008-05-09 11:36:07 
Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error,
tgl@[EMAIL PROTECTED] (T  2008-05-09 11:57:42 
Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather
bruce@[EMAIL PROTECTED]   2008-05-09 11:58:41 
Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather
bruce@[EMAIL PROTECTED]   2008-05-09 17:32:26 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Oct 11 6:34:38 CDT 2008.