Invalid use params in func INDEX 2006-12-25 - By <8B@(protected) CA0=>2
Back
I use MaxDB Version: 7.6.00.16 Build 016-123-109-428 for LINUX
If I execute in "sql studio" procedure "SELECT
PREFS.testIdx('obj1.prop1.prop2.prop4') FROM DUAL" result 5
If I execute in "sql studio" procedure "SELECT
index('obj1.prop1.prop2.prop4', '.', 6, 1) FROM DUAL" result 11
//
DROP FUNCTION PREFS.testIdx
//
CREATE FUNCTION PREFS.testIdx
(
ObjTitle CHAR(1000)
) RETURNS INT
AS
VAR
str VARCHAR(1000);
p SMALLINT;
s INT;
BEGIN
SET str = ObjTitle;
SET p = 1;
SET s = 2;
RETURN index(str, '.', p, s);
END;
//
SELECT PREFS.testIdx('obj1.prop1.prop2.prop4') FROM DUAL
//
SELECT index('obj1.prop1.prop2.prop4', '.', 6, 1) FROM DUAL
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=mysql@(protected)
|
|
