> On Mon, 10 Sep 2001, Tatsuo Ishii wrote:
>
> > In typeconv.sgml we have an example:
> >
> > tgl=> select (4.3 !);
> > ?column?
> > ----------
> > 24
> > (1 row)
>
> Mathematically speaking, one cannot find the factorial of such a
> number. Users could easily cast/round a float to an integer - making it
> suitable for such an operation.
>
> I'd say it was a documentation issue.
My point is the docs claims that PostgreSQL automaticaly converts 4.3
to 4 in this case.
>This example illustrates an interesting result. Traditionally, the
>factorial operator is defined for integers only. The <productname>Postgres</productname>
>operator catalog has only one entry for factorial, taking an integer operand.
>If given a non-integer numeric argument, <productname>Postgres</productname>
>will try to convert that argument to an integer for evaluation of the
>factorial.
--
Tatsuo Ishii
