Changeset: 930e9f47d8c8 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=930e9f47d8c8
Modified Files:
sql/src/sql/skyserver.sql
Branch: default
Log Message:
MS_STR is to replace the str operator from MSsql server.
For the moment it only does a cast, but in the future it needs to take in
consideration the size and the number of decimal digits.
diffs (13 lines):
diff -r f6d91ae9eaeb -r 930e9f47d8c8 sql/src/sql/skyserver.sql
--- a/sql/src/sql/skyserver.sql Thu Sep 23 11:29:45 2010 +0200
+++ b/sql/src/sql/skyserver.sql Thu Sep 23 12:09:58 2010 +0200
@@ -36,3 +36,9 @@
ELSE RETURN ROUND(FLOOR(num), precision);
END IF;
END;
+
+CREATE FUNCTION MS_STR(num float, precision int, truncat int)
+RETURNS string
+BEGIN
+ RETURN CAST(num as string);
+END;
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
