From d7b161031dde7bff0ec09d623ec74246e63b9038 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Thu, 21 Dec 2000 20:48:16 +0000 Subject: [PATCH] Repair round(numeric) function. An initdb would be required to get the fixed version, otherwise you'll continue to encounter breakage. --- src/include/catalog/pg_proc.h | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/src/include/catalog/pg_proc.h b/src/include/catalog/pg_proc.h index cb9ff0ca39..c0914fd601 100644 --- a/src/include/catalog/pg_proc.h +++ b/src/include/catalog/pg_proc.h @@ -7,7 +7,7 @@ * Portions Copyright (c) 1996-2000, PostgreSQL, Inc * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: pg_proc.h,v 1.179 2000/12/10 21:19:02 petere Exp $ + * $Id: pg_proc.h,v 1.180 2000/12/21 20:48:16 petere Exp $ * * NOTES * The script catalog/genbki.sh reads this file and generates .bki @@ -2335,7 +2335,7 @@ DATA(insert OID = 1706 ( sign PGUID 12 f t t t 1 f 1700 "1700" 100 0 0 100 n DESCR("sign of value"); DATA(insert OID = 1707 ( round PGUID 12 f t t t 2 f 1700 "1700 23" 100 0 0 100 numeric_round - )); DESCR("value rounded to 'scale'"); -DATA(insert OID = 1708 ( round PGUID 14 f t t t 1 f 1700 "1700" 100 0 0 100 "select numeric_round($1,0)" - )); +DATA(insert OID = 1708 ( round PGUID 14 f t t t 1 f 1700 "1700" 100 0 0 100 "select round($1,0)" - )); DESCR("value rounded to 'scale' of zero"); DATA(insert OID = 1709 ( trunc PGUID 12 f t t t 2 f 1700 "1700 23" 100 0 0 100 numeric_trunc - )); DESCR("value truncated to 'scale'"); -- 2.40.0