Use 4 - it's close enough :-))

Michael Krzepkowski wrote:
>
> Ravi Krishna wrote:
> > I am converting a SQL Server stored procedure to Informix.
> > In SQL Server there is a function PI() which returns 3.1415926535897931
> > and this can be used in a SQL Server FLOAT variable.
> > When I try to create a datatype in Informix to store the same value,
> > it seems the best I could do is to create FLOAT(16) and it can only
> > take 3.141592653590. Is there a data type in Informix which can take
> > the precise value of PI. Am I missing something?
>
> There is no such thing as a precise value of PI. Just one is
> a little bit more precise than the other.
>
> Michael
>
> >
> > Thanks.
> >
> > Ravi
> >
> >
> >

--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #