aboutsummaryrefslogtreecommitdiff
path: root/src/backend/utils/adt/numeric.c
diff options
context:
space:
mode:
authorJan Wieck <JanWieck@Yahoo.com>1999-09-29 21:13:31 +0000
committerJan Wieck <JanWieck@Yahoo.com>1999-09-29 21:13:31 +0000
commitb5c4b772836e4072de9790c080af6781d3b22d0f (patch)
treeebc1262dd9b19869a24a19a009ea854d253ceb56 /src/backend/utils/adt/numeric.c
parenta6528e08a58e3f5c2ea7fa9410bc7574c42e7f5d (diff)
downloadpostgresql-b5c4b772836e4072de9790c080af6781d3b22d0f.tar.gz
postgresql-b5c4b772836e4072de9790c080af6781d3b22d0f.zip
Added nbtree operator class for NUMERIC
Jan
Diffstat (limited to 'src/backend/utils/adt/numeric.c')
-rw-r--r--src/backend/utils/adt/numeric.c30
1 files changed, 29 insertions, 1 deletions
diff --git a/src/backend/utils/adt/numeric.c b/src/backend/utils/adt/numeric.c
index 97a03d23b83..6df22995575 100644
--- a/src/backend/utils/adt/numeric.c
+++ b/src/backend/utils/adt/numeric.c
@@ -5,7 +5,7 @@
*
* 1998 Jan Wieck
*
- * $Header: /cvsroot/pgsql/src/backend/utils/adt/numeric.c,v 1.19 1999/07/17 20:17:58 momjian Exp $
+ * $Header: /cvsroot/pgsql/src/backend/utils/adt/numeric.c,v 1.20 1999/09/29 21:13:25 wieck Exp $
*
* ----------
*/
@@ -690,6 +690,34 @@ numeric_floor(Numeric num)
*/
+int32
+numeric_cmp(Numeric num1, Numeric num2)
+{
+ int result;
+ NumericVar arg1;
+ NumericVar arg2;
+
+ if (num1 == NULL || num2 == NULL)
+ return (int32)0;
+
+ if (NUMERIC_IS_NAN(num1) || NUMERIC_IS_NAN(num2))
+ return (int32)0;
+
+ init_var(&arg1);
+ init_var(&arg2);
+
+ set_var_from_num(num1, &arg1);
+ set_var_from_num(num2, &arg2);
+
+ result = cmp_var(&arg1, &arg2);
+
+ free_var(&arg1);
+ free_var(&arg2);
+
+ return (int32)((result == 0) ? 0 : ((result < 0) ? -1 : 1));
+}
+
+
bool
numeric_eq(Numeric num1, Numeric num2)
{