Changeset: 94db41afd01d for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=94db41afd01d
Modified Files:
        sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
        sql/test/Tests/systemfunctions.stable.out
        sql/test/leaks/Tests/check1.stable.out
        sql/test/leaks/Tests/check2.stable.out
        sql/test/leaks/Tests/check3.stable.out
        sql/test/leaks/Tests/check4.stable.out
        sql/test/leaks/Tests/check5.stable.out
        sql/test/mapi/Tests/php_monetdb.stable.out
Branch: SciQL-2
Log Message:

approved new signatures added by changeset 81020218708c


diffs (truncated from 1803 to 300 lines):

diff --git 
a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out 
b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
--- a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
+++ b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
@@ -63,11 +63,11 @@ Ready.
 [ 5309,        "queryhistory", 2000,   NULL,   0,      true,   0,      false,  
0       ]
 [ 5323,        "callhistory",  2000,   NULL,   0,      true,   0,      false,  
0       ]
 [ 5340,        "querylog",     2000,   "create view querylog as\nselect qd.*, 
ql.ctime, ql.arguments, ql.exec, ql.result, ql.foot, ql.memory, ql.tuples, 
ql.inblock, ql.oublock from queryhistory qd, callhistory ql\nwhere qd.id = 
ql.id;",   1,      true,   0,      false,  0       ]
-[ 6823,        "files",        6817,   NULL,   0,      false,  0,      false,  
0       ]
-[ 6830,        "catalog",      6817,   NULL,   0,      false,  0,      false,  
0       ]
-[ 7304,        "storagemodelinput",    2000,   NULL,   0,      true,   0,      
false,  0       ]
-[ 7345,        "tablestoragemodel",    2000,   "-- A summary of the table 
storage requirement is is available as a table view.\n-- The auxillary column 
denotes the maximum space if all non-sorted columns\n-- would be augmented with 
a hash (rare situation)\ncreate view sys.tablestoragemodel\nas select 
\"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as 
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(indices) as 
indices,\n\tsum(case when sorted = false then 8 * count else 0 end) as 
auxillary\nfrom sys.storagemodel() group by \"schema\",\"table\";",      1,     
 true,   0,      false,  0       ]
-[ 7367,        "systemfunctions",      2000,   NULL,   0,      true,   0,      
false,  0       ]
+[ 8623,        "files",        8617,   NULL,   0,      false,  0,      false,  
0       ]
+[ 8630,        "catalog",      8617,   NULL,   0,      false,  0,      false,  
0       ]
+[ 9104,        "storagemodelinput",    2000,   NULL,   0,      true,   0,      
false,  0       ]
+[ 9145,        "tablestoragemodel",    2000,   "-- A summary of the table 
storage requirement is is available as a table view.\n-- The auxillary column 
denotes the maximum space if all non-sorted columns\n-- would be augmented with 
a hash (rare situation)\ncreate view sys.tablestoragemodel\nas select 
\"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as 
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(indices) as 
indices,\n\tsum(case when sorted = false then 8 * count else 0 end) as 
auxillary\nfrom sys.storagemodel() group by \"schema\",\"table\";",      1,     
 true,   0,      false,  0       ]
+[ 9167,        "systemfunctions",      2000,   NULL,   0,      true,   0,      
false,  0       ]
 
 # 18:53:13 >  
 # 18:53:13 >  "Done."
diff --git a/sql/test/Tests/systemfunctions.stable.out 
b/sql/test/Tests/systemfunctions.stable.out
--- a/sql/test/Tests/systemfunctions.stable.out
+++ b/sql/test/Tests/systemfunctions.stable.out
@@ -69,6 +69,294 @@ Ready.
 [ "sys",       "alpha",        2,      "double",       ""      ]
 [ "sys",       "area", 0,      "double",       "-- ogc Spatial Analysis 
methods\n\ncreate function area(g geometry) returns float external name 
geom.\"Area\";"        ]
 [ "sys",       "area", 1,      "geometry",     ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val tinyint,  dim1 tinyint, offsets1 tinyint, size1 int) returns 
double external name \"array\".avg;"        ]
+[ "sys",       "array_avg",    1,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val smallint, dim1 tinyint, offsets1 tinyint, size1 int) returns 
double external name \"array\".avg;"        ]
+[ "sys",       "array_avg",    1,      "smallint",     ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val int,      dim1 tinyint, offsets1 tinyint, size1 int) returns 
double external name \"array\".avg;"        ]
+[ "sys",       "array_avg",    1,      "int",  ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val bigint,   dim1 tinyint, offsets1 tinyint, size1 int) returns 
double external name \"array\".avg;"        ]
+[ "sys",       "array_avg",    1,      "bigint",       ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val real,     dim1 tinyint, offsets1 tinyint, size1 int) returns 
double external name \"array\".avg;"        ]
+[ "sys",       "array_avg",    1,      "real", ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val double,   dim1 tinyint, offsets1 tinyint, size1 int) returns 
double external name \"array\".avg;"        ]
+[ "sys",       "array_avg",    1,      "double",       ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val tinyint,  dim1 tinyint, offsets1 tinyint, size1 int, dim2 
tinyint, offsets2 tinyint, size2 int) returns double external name 
\"array\".avg;"     ]
+[ "sys",       "array_avg",    1,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    6,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val smallint, dim1 tinyint, offsets1 tinyint, size1 int, dim2 
tinyint, offsets2 tinyint, size2 int) returns double external name 
\"array\".avg;"     ]
+[ "sys",       "array_avg",    1,      "smallint",     ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    6,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val int,      dim1 tinyint, offsets1 tinyint, size1 int, dim2 
tinyint, offsets2 tinyint, size2 int) returns double external name 
\"array\".avg;"     ]
+[ "sys",       "array_avg",    1,      "int",  ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    6,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val bigint,   dim1 tinyint, offsets1 tinyint, size1 int, dim2 
tinyint, offsets2 tinyint, size2 int) returns double external name 
\"array\".avg;"     ]
+[ "sys",       "array_avg",    1,      "bigint",       ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    6,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val real,     dim1 tinyint, offsets1 tinyint, size1 int, dim2 
tinyint, offsets2 tinyint, size2 int) returns double external name 
\"array\".avg;"     ]
+[ "sys",       "array_avg",    1,      "real", ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    6,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val double,   dim1 tinyint, offsets1 tinyint, size1 int, dim2 
tinyint, offsets2 tinyint, size2 int) returns double external name 
\"array\".avg;"     ]
+[ "sys",       "array_avg",    1,      "double",       ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    6,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val tinyint,  dim1 tinyint, offsets1 tinyint, size1 int, dim2 
tinyint, offsets2 tinyint, size2 int, dim3 tinyint, offsets3 tinyint, size3 
int) returns double external name \"array\".avg;"  ]
+[ "sys",       "array_avg",    1,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    6,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    8,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    9,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    10,     "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val smallint, dim1 tinyint, offsets1 tinyint, size1 int, dim2 
tinyint, offsets2 tinyint, size2 int, dim3 tinyint, offsets3 tinyint, size3 
int) returns double external name \"array\".avg;"  ]
+[ "sys",       "array_avg",    1,      "smallint",     ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    6,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    8,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    9,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    10,     "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val int,      dim1 tinyint, offsets1 tinyint, size1 int, dim2 
tinyint, offsets2 tinyint, size2 int, dim3 tinyint, offsets3 tinyint, size3 
int) returns double external name \"array\".avg;"  ]
+[ "sys",       "array_avg",    1,      "int",  ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    6,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    8,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    9,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    10,     "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val bigint,   dim1 tinyint, offsets1 tinyint, size1 int, dim2 
tinyint, offsets2 tinyint, size2 int, dim3 tinyint, offsets3 tinyint, size3 
int) returns double external name \"array\".avg;"  ]
+[ "sys",       "array_avg",    1,      "bigint",       ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    6,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    8,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    9,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    10,     "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val real,     dim1 tinyint, offsets1 tinyint, size1 int, dim2 
tinyint, offsets2 tinyint, size2 int, dim3 tinyint, offsets3 tinyint, size3 
int) returns double external name \"array\".avg;"  ]
+[ "sys",       "array_avg",    1,      "real", ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    6,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    8,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    9,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    10,     "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val double,   dim1 tinyint, offsets1 tinyint, size1 int, dim2 
tinyint, offsets2 tinyint, size2 int, dim3 tinyint, offsets3 tinyint, size3 
int) returns double external name \"array\".avg;"  ]
+[ "sys",       "array_avg",    1,      "double",       ""      ]
+[ "sys",       "array_avg",    2,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    3,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    6,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    8,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    9,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    10,     "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val tinyint,  dim1 smallint, offsets1 smallint, size1 int) returns 
double external name \"array\".avg;"      ]
+[ "sys",       "array_avg",    1,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    2,      "smallint",     ""      ]
+[ "sys",       "array_avg",    3,      "smallint",     ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val smallint, dim1 smallint, offsets1 smallint, size1 int) returns 
double external name \"array\".avg;"      ]
+[ "sys",       "array_avg",    1,      "smallint",     ""      ]
+[ "sys",       "array_avg",    2,      "smallint",     ""      ]
+[ "sys",       "array_avg",    3,      "smallint",     ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val int,      dim1 smallint, offsets1 smallint, size1 int) returns 
double external name \"array\".avg;"      ]
+[ "sys",       "array_avg",    1,      "int",  ""      ]
+[ "sys",       "array_avg",    2,      "smallint",     ""      ]
+[ "sys",       "array_avg",    3,      "smallint",     ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val bigint,   dim1 smallint, offsets1 smallint, size1 int) returns 
double external name \"array\".avg;"      ]
+[ "sys",       "array_avg",    1,      "bigint",       ""      ]
+[ "sys",       "array_avg",    2,      "smallint",     ""      ]
+[ "sys",       "array_avg",    3,      "smallint",     ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val real,     dim1 smallint, offsets1 smallint, size1 int) returns 
double external name \"array\".avg;"      ]
+[ "sys",       "array_avg",    1,      "real", ""      ]
+[ "sys",       "array_avg",    2,      "smallint",     ""      ]
+[ "sys",       "array_avg",    3,      "smallint",     ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val double,   dim1 smallint, offsets1 smallint, size1 int) returns 
double external name \"array\".avg;"      ]
+[ "sys",       "array_avg",    1,      "double",       ""      ]
+[ "sys",       "array_avg",    2,      "smallint",     ""      ]
+[ "sys",       "array_avg",    3,      "smallint",     ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val tinyint,  dim1 smallint, offsets1 smallint, size1 int, dim2 
smallint, offsets2 smallint, size2 int) returns double external name 
\"array\".avg;" ]
+[ "sys",       "array_avg",    1,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    2,      "smallint",     ""      ]
+[ "sys",       "array_avg",    3,      "smallint",     ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "smallint",     ""      ]
+[ "sys",       "array_avg",    6,      "smallint",     ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val smallint, dim1 smallint, offsets1 smallint, size1 int, dim2 
smallint, offsets2 smallint, size2 int) returns double external name 
\"array\".avg;" ]
+[ "sys",       "array_avg",    1,      "smallint",     ""      ]
+[ "sys",       "array_avg",    2,      "smallint",     ""      ]
+[ "sys",       "array_avg",    3,      "smallint",     ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "smallint",     ""      ]
+[ "sys",       "array_avg",    6,      "smallint",     ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val int,      dim1 smallint, offsets1 smallint, size1 int, dim2 
smallint, offsets2 smallint, size2 int) returns double external name 
\"array\".avg;" ]
+[ "sys",       "array_avg",    1,      "int",  ""      ]
+[ "sys",       "array_avg",    2,      "smallint",     ""      ]
+[ "sys",       "array_avg",    3,      "smallint",     ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "smallint",     ""      ]
+[ "sys",       "array_avg",    6,      "smallint",     ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val bigint,   dim1 smallint, offsets1 smallint, size1 int, dim2 
smallint, offsets2 smallint, size2 int) returns double external name 
\"array\".avg;" ]
+[ "sys",       "array_avg",    1,      "bigint",       ""      ]
+[ "sys",       "array_avg",    2,      "smallint",     ""      ]
+[ "sys",       "array_avg",    3,      "smallint",     ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "smallint",     ""      ]
+[ "sys",       "array_avg",    6,      "smallint",     ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val real,     dim1 smallint, offsets1 smallint, size1 int, dim2 
smallint, offsets2 smallint, size2 int) returns double external name 
\"array\".avg;" ]
+[ "sys",       "array_avg",    1,      "real", ""      ]
+[ "sys",       "array_avg",    2,      "smallint",     ""      ]
+[ "sys",       "array_avg",    3,      "smallint",     ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "smallint",     ""      ]
+[ "sys",       "array_avg",    6,      "smallint",     ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val double,   dim1 smallint, offsets1 smallint, size1 int, dim2 
smallint, offsets2 smallint, size2 int) returns double external name 
\"array\".avg;" ]
+[ "sys",       "array_avg",    1,      "double",       ""      ]
+[ "sys",       "array_avg",    2,      "smallint",     ""      ]
+[ "sys",       "array_avg",    3,      "smallint",     ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "smallint",     ""      ]
+[ "sys",       "array_avg",    6,      "smallint",     ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val tinyint,  dim1 smallint, offsets1 smallint, size1 int, dim2 
smallint, offsets2 smallint, size2 int, dim3 smallint, offsets3 smallint, size3 
int) returns double external name \"array\".avg;"    ]
+[ "sys",       "array_avg",    1,      "tinyint",      ""      ]
+[ "sys",       "array_avg",    2,      "smallint",     ""      ]
+[ "sys",       "array_avg",    3,      "smallint",     ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "smallint",     ""      ]
+[ "sys",       "array_avg",    6,      "smallint",     ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    8,      "smallint",     ""      ]
+[ "sys",       "array_avg",    9,      "smallint",     ""      ]
+[ "sys",       "array_avg",    10,     "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val smallint, dim1 smallint, offsets1 smallint, size1 int, dim2 
smallint, offsets2 smallint, size2 int, dim3 smallint, offsets3 smallint, size3 
int) returns double external name \"array\".avg;"    ]
+[ "sys",       "array_avg",    1,      "smallint",     ""      ]
+[ "sys",       "array_avg",    2,      "smallint",     ""      ]
+[ "sys",       "array_avg",    3,      "smallint",     ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "smallint",     ""      ]
+[ "sys",       "array_avg",    6,      "smallint",     ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    8,      "smallint",     ""      ]
+[ "sys",       "array_avg",    9,      "smallint",     ""      ]
+[ "sys",       "array_avg",    10,     "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val int,      dim1 smallint, offsets1 smallint, size1 int, dim2 
smallint, offsets2 smallint, size2 int, dim3 smallint, offsets3 smallint, size3 
int) returns double external name \"array\".avg;"    ]
+[ "sys",       "array_avg",    1,      "int",  ""      ]
+[ "sys",       "array_avg",    2,      "smallint",     ""      ]
+[ "sys",       "array_avg",    3,      "smallint",     ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "smallint",     ""      ]
+[ "sys",       "array_avg",    6,      "smallint",     ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    8,      "smallint",     ""      ]
+[ "sys",       "array_avg",    9,      "smallint",     ""      ]
+[ "sys",       "array_avg",    10,     "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val bigint,   dim1 smallint, offsets1 smallint, size1 int, dim2 
smallint, offsets2 smallint, size2 int, dim3 smallint, offsets3 smallint, size3 
int) returns double external name \"array\".avg;"    ]
+[ "sys",       "array_avg",    1,      "bigint",       ""      ]
+[ "sys",       "array_avg",    2,      "smallint",     ""      ]
+[ "sys",       "array_avg",    3,      "smallint",     ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "smallint",     ""      ]
+[ "sys",       "array_avg",    6,      "smallint",     ""      ]
+[ "sys",       "array_avg",    7,      "int",  ""      ]
+[ "sys",       "array_avg",    8,      "smallint",     ""      ]
+[ "sys",       "array_avg",    9,      "smallint",     ""      ]
+[ "sys",       "array_avg",    10,     "int",  ""      ]
+[ "sys",       "array_avg",    0,      "double",       "create function 
array_avg(val real,     dim1 smallint, offsets1 smallint, size1 int, dim2 
smallint, offsets2 smallint, size2 int, dim3 smallint, offsets3 smallint, size3 
int) returns double external name \"array\".avg;"    ]
+[ "sys",       "array_avg",    1,      "real", ""      ]
+[ "sys",       "array_avg",    2,      "smallint",     ""      ]
+[ "sys",       "array_avg",    3,      "smallint",     ""      ]
+[ "sys",       "array_avg",    4,      "int",  ""      ]
+[ "sys",       "array_avg",    5,      "smallint",     ""      ]
+[ "sys",       "array_avg",    6,      "smallint",     ""      ]
_______________________________________________
checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list

Reply via email to