Invalid use params in func INDEX

[Дмитрий Русанов]

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/[EMAIL PROTECTED]