From: | Steven Vajdic <svajdic(at)asc(dot)corp(dot)mot(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Integer to float function |
Date: | 2001-04-06 09:27:16 |
Message-ID: | 3ACD8BF4.A996BDB4@asc.corp.mot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(dot)Vajdic(at)motorola(dot)com
email: svajdic(at)asc(dot)corp(dot)mot(dot)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(at)ivillage(dot)com
----------------------------------------
***********************************************
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2001-04-06 12:53:37 | Re: Foreign Key & Rule confusion WAS: Lost Trigger(s)? |
Previous Message | Tom Lane | 2001-04-06 06:49:14 | Re: Re: RC3 ... anyone have anything left outstanding? |