Update of /cvsroot/monetdb/sql/src/test/Skyserver
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv14383
Modified Files:
Tag: SQL_2-24
Skyserver_functions_v6.sql
Log Message:
Correct the function to avoid errors...
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.9
retrieving revision 1.1.2.10
diff -u -d -r1.1.2.9 -r1.1.2.10
--- Skyserver_functions_v6.sql 6 Jun 2008 14:45:59 -0000 1.1.2.9
+++ Skyserver_functions_v6.sql 8 Jun 2008 18:25:05 -0000 1.1.2.10
@@ -2266,8 +2266,9 @@
CREATE FUNCTION fGetUrlFitsSpectrum(specObjIdd bigint)
RETURNS varchar(128)
BEGIN
- DECLARE link varchar(128), plate varchar(8), mjd varchar(8), fiber
varchar(8), rerun int;
- SET link = (select value from SiteConstants where
name='DataServerURL'); SET rerun=(select p.spRerun from specobjall s,
platex p where s.plateid=p.plateid and s.specobjid=specObjIdd);
+ DECLARE link varchar(128), plate varchar(16), mjd varchar(16), fiber
varchar(16), rerun int;
+ SET link = (select value from SiteConstants where
name='DataServerURL');
+ SET rerun=(select p.spRerun from specobjall s, platex p where
s.plateid=p.plateid and s.specobjid=specObjIdd);
SET link = link + 'spectro/1d_' + cast(rerun as varchar(4)) + '/';
SELECT cast(p.mjd as varchar(8)) into mjd
FROM PlateX p, specObjAll s
-------------------------------------------------------------------------
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
