Oninit cdi / Archive
Talk to an expert →

Re: storing the value of PI

Posted in 2003

Topics: Stored Procedures & SPL, Data Types & Schema Design, Third-Party Tools & Monitoring

Paul Watson — — source: Usenet: comp.databases.informix

Some guy in the late 1800s use 4 'cos it's has a nice root. Then he was surprised when the clocks where wrong, he got lost a lot .... Cheers Obnoxio The Clown wrote: > > Paul Watson wrote: > > > Use 4 - it's close enough :-)) > > 3 is closer, though. > > > 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. > > -- > "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" > - Coluche -- 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 #

↪ replying to Paul Watson
Obnoxio The Clown — — source: Usenet: comp.databases.informix

Paul Watson wrote: > Some guy in the late 1800s use 4 'cos it's has a nice root. Then > he was surprised when the clocks where wrong, he got lost a lot .... Had a nice root, did he? Fnaar...! > Obnoxio The Clown wrote: >> >> Paul Watson wrote: >> >> > Use 4 - it's close enough :-)) >> >> 3 is closer, though. >> >> > 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. >> >> -- >> "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" >> - Coluche > -- "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche

↪ replying to Obnoxio The Clown
Captain Pedantic — — source: Usenet: comp.databases.informix

"Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message news:brac46$15fr3$2@ID-64669.news.uni-berlin.de... > Paul Watson wrote: > > > Some guy in the late 1800s use 4 'cos it's has a nice root. Then > > he was surprised when the clocks where wrong, he got lost a lot .... > > Had a nice root, did he? Fnaar...! Definition of an Australian's foreplay: "Fancy a root, darlin' ?"

Related threads