Re: Decimal exponent (power) in i4gl?

Dirk Gunsthoevel wrote: > > Peter Lancashire schrieb: > > > > Manuel A. Daponte Santiago wrote: > > > > > > In i4gl there is the ** operand to raise a number to a power, but it > > > only handles integers (2 ** 2.5 = 4). > > > > > > Does somebody know hot to perform this operation? > > > > > > Thanks in advance > > > > The database engine from version 7.1 can do it (extract from manual): > > > > POW Function > > > > The POW function raises the base to the exponent. This function requires > > two numeric arguments. The return type is FLOAT. The following example > > returns all the information for circles whose areas ( p r 2 ) are less > > than 1,000 square units: > > > > SELECT * FROM circles WHERE (3.1417 * POW(radius,2)) < 1000 > ^> > I would like to buy squares from you. Would you trade your squares > for circles of equal area? ;> > > Sorry, couldnt resist > Dirk No, I wouldn't, but I'll see if the writer of the Informix manuals is interested in trading gold sheets. Would it be worse if they had written 1000.00? (A (devious) exercise for the reader.) Perhaps my sig should read: If all else fails, read the instructions AND the release notes but check any maths you find in them. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions AND the release notes. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/