Thread

1. Integer to float function

   Steven Vajdic <svajdic@asc.corp.mot.com> — 2001-04-06T09:27:16Z

   
   Einar Karttunen wrote:
   
   >
   > >
   > > integer (float_expression) or int (float_expression) DO work on
   > RedHat6.2/PostgreSQL6.5 and DO NOT work on Mandrake/PostgreSQL7.0.2
   
   > Try using int2()/int4()/int8() instead of integer(). The intn()
   functions
   > convert the float to a integer n bytes long, in normal cases you
   probably
   > want to use int4().
   >
   
   Einar,
   
   Much obliged.
   
   int4() has done a job.
   
   Why is that NOT documented under "Matematical functions"?
   
   Regards,
   
   
   Steven.
   
   --
   ***********************************************
   
   Steven Vajdic (BSc/Hon, MSc)
   Senior Software Engineer
   Motorola Australia Software Centre (MASC)
   2 Second Avenue, Technology Park
   Adelaide, South Australia  5095
   email:  Steven.Vajdic@motorola.com
   email:  svajdic@asc.corp.mot.com
   Ph.:  +61-8-8168-3435
   Fax:    +61-8-8168-3501
   Front Office (Ph): +61-8-8168-3500
   
   ----------------------------------------
   mobile: +61 (0)419 860 903
   AFTER WORK email:  steven_vajdic@ivillage.com
   ----------------------------------------
   
   ***********************************************
   
   
   
   

2. Re: Integer to float function

   Thomas Lockhart <lockhart@alumni.caltech.edu> — 2001-04-06T13:46:22Z

   > > > integer (float_expression) or int (float_expression) DO work on
   > > RedHat6.2/PostgreSQL6.5 and DO NOT work on Mandrake/PostgreSQL7.0.2
   > > Try using int2()/int4()/int8() instead of integer().
   > Why is that NOT documented under "Matematical functions"?
   
   Because we haven't received any patches to document it? ;)
   
                        - Thomas
   
   

3. Re: Integer to float function

   Peter Eisentraut <peter_e@gmx.net> — 2001-04-06T14:39:22Z

   Steven Vajdic writes:
   
   > int4() has done a job.
   >
   > Why is that NOT documented under "Matematical functions"?
   
   Because you're supposed to use CAST(value AS integer).
   
   -- 
   Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/
   
   
   

4. Re: Re: Integer to float function

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-04-06T14:54:49Z

   Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
   > Try using int2()/int4()/int8() instead of integer().
   >> Why is that NOT documented under "Matematical functions"?
   
   > Because we haven't received any patches to document it? ;)
   
   Or because it's not a mathematical function.  I don't think that
   datatype conversion functions belong under that heading.
   
   			regards, tom lane