2
* The contents of this file are subject to the Initial
3
* Developer's Public License Version 1.0 (the "License");
4
* you may not use this file except in compliance with the
5
* License. You may obtain a copy of the License at
6
* http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_idpl.
8
* Software distributed under the License is distributed AS IS,
9
* WITHOUT WARRANTY OF ANY KIND, either express or implied.
10
* See the License for the specific language governing rights
11
* and limitations under the License.
13
* The Original Code was created by Claudio Valderrama on 20-Sept-2004
14
* for the Firebird Open Source RDBMS project.
16
* Copyright (c) 2004 Claudio Valderrama
17
* and all contributors signed below.
19
* All Rights Reserved.
20
* Contributor(s): ______________________________________.
24
-- Warning: this script should be used only when you are using the new ib_udf
25
-- library together with Firebird v2 and want to detect NULL correctly.
27
update rdb$function_arguments
29
where rdb$function_name = 'ASCII_CHAR'
30
and rdb$argument_position = 1;
32
update rdb$function_arguments
34
where rdb$function_name = 'LOWER'
35
and rdb$argument_position = 1;
37
update rdb$function_arguments
39
where rdb$function_name = 'LPAD'
40
and rdb$argument_position in (1, 3);
42
update rdb$function_arguments
44
where rdb$function_name = 'LTRIM'
45
and rdb$argument_position = 1;
47
update rdb$function_arguments
49
where rdb$function_name = 'RPAD'
50
and rdb$argument_position in (1, 3);
52
update rdb$function_arguments
54
where rdb$function_name = 'RTRIM'
55
and rdb$argument_position = 1;
57
update rdb$function_arguments
59
where rdb$function_name = 'SUBSTR'
60
and rdb$argument_position = 1;
62
update rdb$function_arguments
64
where rdb$function_name = 'SUBSTRLEN'
65
and rdb$argument_position = 1;