Update of /cvsroot/monetdb/sql/src/test/Skyserver
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv20606
Modified Files:
Tag: SQL_2-24
Skyserver_functions.sql Skyserver_functions_v6.sql
Log Message:
Fix the last str operator problem...
U Skyserver_functions.sql
Index: Skyserver_functions.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_functions.sql,v
retrieving revision 1.20.2.2
retrieving revision 1.20.2.3
diff -u -d -r1.20.2.2 -r1.20.2.3
--- Skyserver_functions.sql 23 Jun 2008 08:05:44 -0000 1.20.2.2
+++ Skyserver_functions.sql 23 Jun 2008 09:16:41 -0000 1.20.2.3
@@ -1491,7 +1491,7 @@
BEGIN
DECLARE cmd varchar(100);
SET cmd = 'CARTESIAN 20 '
- ||str(x,15)||' '||str(y,15)||' '||str(z,15);
+ ||cast(round(x,7) as varchar(15))||' '||cast(round(y,7) as
varchar(15))||' '||cast(round(z,7) as varchar(15));
RETURN fHtmLookup(cmd);
END;
U Skyserver_functions_v6.sql
Index: Skyserver_functions_v6.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_functions_v6.sql,v
retrieving revision 1.1.2.13
retrieving revision 1.1.2.14
diff -u -d -r1.1.2.13 -r1.1.2.14
--- Skyserver_functions_v6.sql 23 Jun 2008 08:05:45 -0000 1.1.2.13
+++ Skyserver_functions_v6.sql 23 Jun 2008 09:16:41 -0000 1.1.2.14
@@ -1491,7 +1491,7 @@
BEGIN
DECLARE cmd varchar(100);
SET cmd = 'CARTESIAN 20 '
- ||str(x,15)||' '||str(y,15)||' '||str(z,15);
+ ||cast(round(x,7) as varchar(15))||' '||cast(round(y,7) as
varchar(15))||' '||cast(round(z,7) as varchar(15));
RETURN fHtmLookup(cmd);
END;
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
