Re: select exp(column)
Posted in 1996
Topics: Stored Procedures & SPL, Third-Party Tools & Monitoring
the way the manual states the definition of the exp() function is a little misleading. you don't actually provide the constant. the constant is implied, and has the value "e". so, you only provide the float expression. -joe- (huddles@hasting.com) ---------- From: informix-list-owner To: jparker Cc: informix-list Subject: Re: select exp(column) Date: Thursday, March 07, 1996 8:57AM Its actually in the manual: Informix Guide to SQL v. 7.1 p 1-570. Its the exponential value of two numeric expressions although I can't make it work trying to paprallel the example in the manual: select exp(3) from angles -- Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; Ft. Collins CO 80523, USofA; 970-491-1244 FAX 970-491-1205 cwoodall@vth1.vth.colostate.edu "Ask me about my vow of silence!" -- On Wed, 6 Mar 1996, Jack Parker wrote: } } What? } } I was going to right an exponientiation SPL and just for grins did a } select col * exp(other_col) from table. It worked! But its not an } exponentiation function what is it? } } select exp(2) } from systables } where tabid = 1 } } yields 7.39 } } select 2 * exp(2) } from systables } where tabid = 1 } } yields 15 } } ?????? } } cheers } j. } _____________________________________________________________________________ } Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA } jparker@hpbs3645.boi.hp.com } _____________________________________________________________________________ } } If anything can go wrong, fix it. To hell with Murphy. } _____________________________________________________________________________ } Any opinions expressed herein are my own and not those of my employers. } _____________________________________________________________________________ }