MonetDB: Oct2014 - added some more missing sql function definitions

[Niels Nes]

Changeset: 9a2cf4c75ba5 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9a2cf4c75ba5
Modified Files:
        sql/common/sql_types.c
Branch: Oct2014
Log Message:

added some more missing sql function definitions


diffs (44 lines):

diff --git a/sql/common/sql_types.c b/sql/common/sql_types.c
--- a/sql/common/sql_types.c
+++ b/sql/common/sql_types.c
@@ -1372,13 +1372,14 @@ sqltypeinit( sql_allocator *sa)
        sql_create_func(sa, "localtime", "sql", "current_time", NULL, NULL, 
TME, SCALE_NONE);
        sql_create_func(sa, "localtimestamp", "sql", "current_timestamp", NULL, 
NULL, TMESTAMP, SCALE_NONE);
 
-       sql_create_func(sa, "sql_sub", "mtime", "date_sub_msec_interval", DTE, 
SECINT, DTE, SCALE_FIX);
-       sql_create_func(sa, "sql_sub", "mtime", "date_sub_month_interval", DTE, 
MONINT, DTE, SCALE_FIX);
-       sql_create_func(sa, "sql_sub", "mtime", "timestamp_sub_msec_interval", 
TMESTAMP, SECINT, TMESTAMP, SCALE_FIX);
-       sql_create_func(sa, "sql_sub", "mtime", "timestamp_sub_month_interval", 
TMESTAMP, MONINT, TMESTAMP, SCALE_FIX);
-       sql_create_func(sa, "sql_sub", "mtime", "timestamp_sub_msec_interval", 
TMESTAMPTZ, SECINT, TMESTAMPTZ, SCALE_FIX);
-       sql_create_func(sa, "sql_sub", "mtime", "timestamp_sub_month_interval", 
TMESTAMPTZ, MONINT, TMESTAMPTZ, SCALE_FIX);
-       sql_create_func(sa, "sql_sub", "mtime", "time_sub_msec_interval", TME, 
SECINT, TME, SCALE_FIX);
+       sql_create_func(sa, "sql_sub", "mtime", "date_sub_msec_interval", DTE, 
SECINT, DTE, SCALE_NONE);
+       sql_create_func(sa, "sql_sub", "mtime", "date_sub_month_interval", DTE, 
MONINT, DTE, SCALE_NONE);
+       sql_create_func(sa, "sql_sub", "mtime", "timestamp_sub_msec_interval", 
TMESTAMP, SECINT, TMESTAMP, SCALE_NONE);
+       sql_create_func(sa, "sql_sub", "mtime", "timestamp_sub_month_interval", 
TMESTAMP, MONINT, TMESTAMP, SCALE_NONE);
+       sql_create_func(sa, "sql_sub", "mtime", "timestamp_sub_msec_interval", 
TMESTAMPTZ, SECINT, TMESTAMPTZ, SCALE_NONE);
+       sql_create_func(sa, "sql_sub", "mtime", "timestamp_sub_month_interval", 
TMESTAMPTZ, MONINT, TMESTAMPTZ, SCALE_NONE);
+       sql_create_func(sa, "sql_sub", "mtime", "time_sub_msec_interval", TME, 
SECINT, TME, SCALE_NONE);
+       sql_create_func(sa, "sql_sub", "mtime", "time_sub_msec_interval", 
TMETZ, SECINT, TMETZ, SCALE_NONE);
 
        sql_create_func(sa, "sql_sub", "mtime", "diff", DTE, DTE, INT, 
SCALE_FIX);
        sql_create_func(sa, "sql_sub", "mtime", "diff", TMESTAMP, TMESTAMP, 
LNG, SCALE_FIX);
@@ -1391,6 +1392,8 @@ sqltypeinit( sql_allocator *sa)
        sql_create_func(sa, "sql_add", "mtime", "timestamp_add_msec_interval", 
TMESTAMPTZ, SECINT, TMESTAMPTZ, SCALE_NONE);
        sql_create_func(sa, "sql_add", "mtime", "timestamp_add_month_interval", 
TMESTAMPTZ, MONINT, TMESTAMPTZ, SCALE_NONE);
        sql_create_func(sa, "sql_add", "mtime", "time_add_msec_interval", TME, 
SECINT, TME, SCALE_NONE);
+       sql_create_func(sa, "sql_add", "mtime", "time_add_msec_interval", 
TMETZ, SECINT, TMETZ, SCALE_NONE);
+
        sql_create_func(sa, "local_timezone", "mtime", "local_timezone", NULL, 
NULL, SECINT, SCALE_FIX);
 
        sql_create_func(sa, "year", "mtime", "year", DTE, NULL, INT, SCALE_FIX);
@@ -1399,6 +1402,9 @@ sqltypeinit( sql_allocator *sa)
        sql_create_func(sa, "hour", "mtime", "hours", TME, NULL, INT, 
SCALE_FIX);
        sql_create_func(sa, "minute", "mtime", "minutes", TME, NULL, INT, 
SCALE_FIX);
        sql_create_func_res(sa, "second", "mtime", "sql_seconds", TME, NULL, 
DEC, SCALE_NONE, 3);
+       sql_create_func(sa, "hour", "mtime", "hours", TMETZ, NULL, INT, 
SCALE_FIX);
+       sql_create_func(sa, "minute", "mtime", "minutes", TMETZ, NULL, INT, 
SCALE_FIX);
+       sql_create_func_res(sa, "second", "mtime", "sql_seconds", TMETZ, NULL, 
DEC, SCALE_NONE, 3);
 
        sql_create_func(sa, "year", "mtime", "year", TMESTAMP, NULL, INT, 
SCALE_FIX);
        sql_create_func(sa, "month", "mtime", "month", TMESTAMP, NULL, INT, 
SCALE_FIX);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list