From e2ac58c7bd3e714bdf6c140b459c94b454b7b291 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 1 Dec 2003 21:53:15 +0000 Subject: [PATCH] Remove mention of factorial as casting example. New example needed. --- doc/src/sgml/typeconv.sgml | 26 +------------------------- 1 file changed, 1 insertion(+), 25 deletions(-) diff --git a/doc/src/sgml/typeconv.sgml b/doc/src/sgml/typeconv.sgml index 216b339bd7..bd68c242b3 100644 --- a/doc/src/sgml/typeconv.sgml +++ b/doc/src/sgml/typeconv.sgml @@ -1,5 +1,5 @@ @@ -437,30 +437,6 @@ SELECT @ '-4.5e500' AS "abs"; ERROR: "-4.5e500" is out of range for type double precision - - -On the other hand, the postfix operator ! (factorial) -is defined only for integer data types, not for float8. So, if we -try a similar case with !, we get: - -SELECT '20' ! AS "factorial"; - -ERROR: operator is not unique: "unknown" ! -HINT: Could not choose a best candidate operator. You may need to add explicit -type casts. - -This happens because the system can't decide which of the several -possible ! operators should be preferred. We can help -it out with an explicit cast: - -SELECT CAST('20' AS int8) ! AS "factorial"; - - factorial ---------------------- - 2432902008176640000 -(1 row) - - -- 2.40.0