Integer to float function

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

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/

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

On Fri, 06 April 2001, Tom Lane wrote:

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

I did not mean to question the position
of integre() or int4(), or ... in the PostgreSQL documents.

I HAVE found a list of functions, among them integer(), under mathematical functions and have NOT found anything about int4() or intn(), should I say. Perhaps, I was not searching the docs enough, but you know how we do things in a hurry - we do search the TOC.

So, if there is intn() desribed somewhere in the docs, I apologise BUT there is not then we have a communication problem.

Thanks in any case. The most important thing is that my migration from RedHat6.2/postgreSQL6.5 to Mandrake/PostgreSQL7.0.2 was easy and successfull, mostly because of this forum and questions/answers that we have
in circulation.

Cheers,

Steven.

_________________________________________________________________
iVillage.com: Solutions for Your Life
Check out the most exciting women's community on the Web
http://www.ivillage.com