http://git-wip-us.apache.org/repos/asf/incubator-madlib-site/blob/b5b51c69/docs/v1.11/array__ops_8sql__in.html ---------------------------------------------------------------------- diff --git a/docs/v1.11/array__ops_8sql__in.html b/docs/v1.11/array__ops_8sql__in.html new file mode 100644 index 0000000..4a69b32 --- /dev/null +++ b/docs/v1.11/array__ops_8sql__in.html @@ -0,0 +1,1262 @@ +<!-- HTML header for doxygen 1.8.4--> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> +<html xmlns="http://www.w3.org/1999/xhtml";> +<head> +<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/> +<meta http-equiv="X-UA-Compatible" content="IE=9"/> +<meta name="generator" content="Doxygen 1.8.13"/> +<meta name="keywords" content="madlib,postgres,greenplum,machine learning,data mining,deep learning,ensemble methods,data science,market basket analysis,affinity analysis,pca,lda,regression,elastic net,huber white,proportional hazards,k-means,latent dirichlet allocation,bayes,support vector machines,svm"/> +<title>MADlib: array_ops.sql_in File Reference</title> +<link href="tabs.css" rel="stylesheet" type="text/css"/> +<script type="text/javascript" src="jquery.js"></script> +<script type="text/javascript" src="dynsections.js"></script> +<link href="navtree.css" rel="stylesheet" type="text/css"/> +<script type="text/javascript" src="resize.js"></script> +<script type="text/javascript" src="navtreedata.js"></script> +<script type="text/javascript" src="navtree.js"></script> +<script type="text/javascript"> + $(document).ready(initResizable); +</script> +<link href="search/search.css" rel="stylesheet" type="text/css"/> +<script type="text/javascript" src="search/searchdata.js"></script> +<script type="text/javascript" src="search/search.js"></script> +<script type="text/javascript"> + $(document).ready(function() { init_search(); }); +</script> +<!-- hack in the navigation tree --> +<script type="text/javascript" src="eigen_navtree_hacks.js"></script> +<link href="doxygen.css" rel="stylesheet" type="text/css" /> +<link href="madlib_extra.css" rel="stylesheet" type="text/css"/> +<!-- google analytics --> +<script> + (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ + (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), + m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) + })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); + ga('create', 'UA-45382226-1', 'madlib.incubator.apache.org'); + ga('send', 'pageview'); +</script> +</head> +<body> +<div id="top"><!-- do not remove this div, it is closed by doxygen! --> +<div id="titlearea"> +<table cellspacing="0" cellpadding="0"> + <tbody> + <tr style="height: 56px;"> + <td id="projectlogo"><a href="http://madlib.incubator.apache.org";><img alt="Logo" src="madlib.png" height="50" style="padding-left:0.5em;" border="0"/ ></a></td> + <td style="padding-left: 0.5em;"> + <div id="projectname"> + <span id="projectnumber">1.11</span> + </div> + <div id="projectbrief">User Documentation for MADlib</div> + </td> + <td> <div id="MSearchBox" class="MSearchBoxInactive"> + <span class="left"> + <img id="MSearchSelect" src="search/mag_sel.png" + onmouseover="return searchBox.OnSearchSelectShow()" + onmouseout="return searchBox.OnSearchSelectHide()" + alt=""/> + <input type="text" id="MSearchField" value="Search" accesskey="S" + onfocus="searchBox.OnSearchFieldFocus(true)" + onblur="searchBox.OnSearchFieldFocus(false)" + onkeyup="searchBox.OnSearchFieldChange(event)"/> + </span><span class="right"> + <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a> + </span> + </div> +</td> + </tr> + </tbody> +</table> +</div> +<!-- end header part --> +<!-- Generated by Doxygen 1.8.13 --> +<script type="text/javascript"> +var searchBox = new SearchBox("searchBox", "search",false,'Search'); +</script> +</div><!-- top --> +<div id="side-nav" class="ui-resizable side-nav-resizable"> + <div id="nav-tree"> + <div id="nav-tree-contents"> + <div id="nav-sync" class="sync"></div> + </div> + </div> + <div id="splitbar" style="-moz-user-select:none;" + class="ui-resizable-handle"> + </div> +</div> +<script type="text/javascript"> +$(document).ready(function(){initNavTree('array__ops_8sql__in.html','');}); +</script> +<div id="doc-content"> +<!-- window showing the filter options --> +<div id="MSearchSelectWindow" + onmouseover="return searchBox.OnSearchSelectShow()" + onmouseout="return searchBox.OnSearchSelectHide()" + onkeydown="return searchBox.OnSearchSelectKey(event)"> +</div> + +<!-- iframe showing the search results (closed by default) --> +<div id="MSearchResultsWindow"> +<iframe src="javascript:void(0)" frameborder="0" + name="MSearchResults" id="MSearchResults"> +</iframe> +</div> + +<div class="header"> + <div class="summary"> +<a href="#func-members">Functions</a> </div> + <div class="headertitle"> +<div class="title">array_ops.sql_in File Reference</div> </div> +</div><!--header--> +<div class="contents"> + +<p>implementation of array operations in SQL +<a href="#details">More...</a></p> +<table class="memberdecls"> +<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="func-members"></a> +Functions</h2></td></tr> +<tr class="memitem:a91c8d3715142927b3967f05a4fbf1575"><td class="memItemLeft" align="right" valign="top">anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a91c8d3715142927b3967f05a4fbf1575">array_add</a> (anyarray x, anyarray y)</td></tr> +<tr class="memdesc:a91c8d3715142927b3967f05a4fbf1575"><td class="mdescLeft"> </td><td class="mdescRight">Adds two arrays. It requires that all the values are NON-NULL. Return type is the same as the input type. <a href="#a91c8d3715142927b3967f05a4fbf1575">More...</a><br /></td></tr> +<tr class="separator:a91c8d3715142927b3967f05a4fbf1575"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a26e8508a2bae10a6574cec697a270eea"><td class="memItemLeft" align="right" valign="top">aggregate anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a26e8508a2bae10a6574cec697a270eea">sum</a> (anyarray)</td></tr> +<tr class="memdesc:a26e8508a2bae10a6574cec697a270eea"><td class="mdescLeft"> </td><td class="mdescRight">Aggregate, element-wise sum of arrays. It requires that all the values are NON-NULL. Return type is the same as the input type. <a href="#a26e8508a2bae10a6574cec697a270eea">More...</a><br /></td></tr> +<tr class="separator:a26e8508a2bae10a6574cec697a270eea"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a2875a161a01c7dcdea9a4997b074eefc"><td class="memItemLeft" align="right" valign="top">anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a2875a161a01c7dcdea9a4997b074eefc">array_sub</a> (anyarray x, anyarray y)</td></tr> +<tr class="memdesc:a2875a161a01c7dcdea9a4997b074eefc"><td class="mdescLeft"> </td><td class="mdescRight">Subtracts two arrays. It requires that all the values are NON-NULL. Return type is the same as the input type. <a href="#a2875a161a01c7dcdea9a4997b074eefc">More...</a><br /></td></tr> +<tr class="separator:a2875a161a01c7dcdea9a4997b074eefc"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a652d70c480d484c4a1a92ded384b0dd7"><td class="memItemLeft" align="right" valign="top">anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a652d70c480d484c4a1a92ded384b0dd7">array_mult</a> (anyarray x, anyarray y)</td></tr> +<tr class="memdesc:a652d70c480d484c4a1a92ded384b0dd7"><td class="mdescLeft"> </td><td class="mdescRight">Element-wise product of two arrays. It requires that all the values are NON-NULL. Return type is the same as the input type. <a href="#a652d70c480d484c4a1a92ded384b0dd7">More...</a><br /></td></tr> +<tr class="separator:a652d70c480d484c4a1a92ded384b0dd7"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a6cc05e7052495f8b64692faf40219576"><td class="memItemLeft" align="right" valign="top">anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a6cc05e7052495f8b64692faf40219576">array_div</a> (anyarray x, anyarray y)</td></tr> +<tr class="memdesc:a6cc05e7052495f8b64692faf40219576"><td class="mdescLeft"> </td><td class="mdescRight">Element-wise division of two arrays. It requires that all the values are NON-NULL. Return type is the same as the input type. <a href="#a6cc05e7052495f8b64692faf40219576">More...</a><br /></td></tr> +<tr class="separator:a6cc05e7052495f8b64692faf40219576"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:acde10964ed23b7c8da515fb84cb8d5e0"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#acde10964ed23b7c8da515fb84cb8d5e0">array_dot</a> (anyarray x, anyarray y)</td></tr> +<tr class="memdesc:acde10964ed23b7c8da515fb84cb8d5e0"><td class="mdescLeft"> </td><td class="mdescRight">Dot-product of two arrays. It requires that all the values are NON-NULL. Return type is the same as the input type. <a href="#acde10964ed23b7c8da515fb84cb8d5e0">More...</a><br /></td></tr> +<tr class="separator:acde10964ed23b7c8da515fb84cb8d5e0"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:aedf6cb13eb4803bcc12dc4d95ea8ff4e"><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#aedf6cb13eb4803bcc12dc4d95ea8ff4e">array_contains</a> (anyarray x, anyarray y)</td></tr> +<tr class="memdesc:aedf6cb13eb4803bcc12dc4d95ea8ff4e"><td class="mdescLeft"> </td><td class="mdescRight">Checks whether one array contains the other. This function returns TRUE if each non-zero element in the right array equals to the element with the same index in the left array. <a href="#aedf6cb13eb4803bcc12dc4d95ea8ff4e">More...</a><br /></td></tr> +<tr class="separator:aedf6cb13eb4803bcc12dc4d95ea8ff4e"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:ae891429cc50705c530f3e5ca15541849"><td class="memItemLeft" align="right" valign="top">anyelement </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#ae891429cc50705c530f3e5ca15541849">array_max</a> (anyarray x)</td></tr> +<tr class="memdesc:ae891429cc50705c530f3e5ca15541849"><td class="mdescLeft"> </td><td class="mdescRight">This function finds the maximum value in the array. NULLs are ignored. Return type is the same as the input type. <a href="#ae891429cc50705c530f3e5ca15541849">More...</a><br /></td></tr> +<tr class="separator:ae891429cc50705c530f3e5ca15541849"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:aa415256a9064aecc600dfb5e377fb7b1"><td class="memItemLeft" align="right" valign="top">float8 [] </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#aa415256a9064aecc600dfb5e377fb7b1">array_max_index</a> (anyarray x)</td></tr> +<tr class="memdesc:aa415256a9064aecc600dfb5e377fb7b1"><td class="mdescLeft"> </td><td class="mdescRight">This function finds the maximum value and corresponding index in the array. NULLs are ignored. Return type is the same as the input type. <a href="#aa415256a9064aecc600dfb5e377fb7b1">More...</a><br /></td></tr> +<tr class="separator:aa415256a9064aecc600dfb5e377fb7b1"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a6659bf9d9363eb179fab34f81f8ac59b"><td class="memItemLeft" align="right" valign="top">anyelement </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a6659bf9d9363eb179fab34f81f8ac59b">array_min</a> (anyarray x)</td></tr> +<tr class="memdesc:a6659bf9d9363eb179fab34f81f8ac59b"><td class="mdescLeft"> </td><td class="mdescRight">This function finds the minimum value in the array. NULLs are ignored. Return type is the same as the input type. <a href="#a6659bf9d9363eb179fab34f81f8ac59b">More...</a><br /></td></tr> +<tr class="separator:a6659bf9d9363eb179fab34f81f8ac59b"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a813a4d9ffc1c18b1b3e18f6ecdb2051f"><td class="memItemLeft" align="right" valign="top">float8 [] </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a813a4d9ffc1c18b1b3e18f6ecdb2051f">array_min_index</a> (anyarray x)</td></tr> +<tr class="memdesc:a813a4d9ffc1c18b1b3e18f6ecdb2051f"><td class="mdescLeft"> </td><td class="mdescRight">This function finds the minimum value and corresponding index in the array. NULLs are ignored. Return type is the same as the input type. <a href="#a813a4d9ffc1c18b1b3e18f6ecdb2051f">More...</a><br /></td></tr> +<tr class="separator:a813a4d9ffc1c18b1b3e18f6ecdb2051f"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a4c98f20e6a737358806f63318daea5ec"><td class="memItemLeft" align="right" valign="top">anyelement </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a4c98f20e6a737358806f63318daea5ec">array_sum</a> (anyarray x)</td></tr> +<tr class="memdesc:a4c98f20e6a737358806f63318daea5ec"><td class="mdescLeft"> </td><td class="mdescRight">This function finds the sum of the values in the array. NULLs are ignored. Return type is the same as the input type. <a href="#a4c98f20e6a737358806f63318daea5ec">More...</a><br /></td></tr> +<tr class="separator:a4c98f20e6a737358806f63318daea5ec"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a418de59800833aa95f9b7cbd6b12901c"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a418de59800833aa95f9b7cbd6b12901c">array_sum_big</a> (anyarray x)</td></tr> +<tr class="memdesc:a418de59800833aa95f9b7cbd6b12901c"><td class="mdescLeft"> </td><td class="mdescRight">This function finds the sum of the values in the array. NULLs are ignored. Return type is always FLOAT8 regardless of input. This function is meant to replace <a class="el" href="array__ops_8sql__in.html#a4c98f20e6a737358806f63318daea5ec" title="This function finds the sum of the values in the array. NULLs are ignored. Return type is the same as...">array_sum()</a> in the cases when sum may overflow the element type. <a href="#a418de59800833aa95f9b7cbd6b12901c">More...</a><br /></td></tr> +<tr class="separator:a418de59800833aa95f9b7cbd6b12901c"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a13c0b0c53e8b0dc4e08c21bb8152ee7d"><td class="memItemLeft" align="right" valign="top">anyelement </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a13c0b0c53e8b0dc4e08c21bb8152ee7d">array_abs_sum</a> (anyarray x)</td></tr> +<tr class="memdesc:a13c0b0c53e8b0dc4e08c21bb8152ee7d"><td class="mdescLeft"> </td><td class="mdescRight">This function finds the sum of abs of the values in the array. NULLs are ignored. Return type is the same as the input type. <a href="#a13c0b0c53e8b0dc4e08c21bb8152ee7d">More...</a><br /></td></tr> +<tr class="separator:a13c0b0c53e8b0dc4e08c21bb8152ee7d"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:ac14e74c10b58f5518cd0e3e56067e5ba"><td class="memItemLeft" align="right" valign="top">anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#ac14e74c10b58f5518cd0e3e56067e5ba">array_abs</a> (anyarray x)</td></tr> +<tr class="memdesc:ac14e74c10b58f5518cd0e3e56067e5ba"><td class="mdescLeft"> </td><td class="mdescRight">This function takes an array as the input and finds absolute value of each element in the array, returning the resulting array. It requires that all the values are NON-NULL. <a href="#ac14e74c10b58f5518cd0e3e56067e5ba">More...</a><br /></td></tr> +<tr class="separator:ac14e74c10b58f5518cd0e3e56067e5ba"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a407598f9eb70637798b02fd731bfca2c"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a407598f9eb70637798b02fd731bfca2c">array_mean</a> (anyarray x)</td></tr> +<tr class="memdesc:a407598f9eb70637798b02fd731bfca2c"><td class="mdescLeft"> </td><td class="mdescRight">This function finds the mean of the values in the array. NULLs are ignored. <a href="#a407598f9eb70637798b02fd731bfca2c">More...</a><br /></td></tr> +<tr class="separator:a407598f9eb70637798b02fd731bfca2c"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a3b6c2d173a611e6d6b184d825c2b336d"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a3b6c2d173a611e6d6b184d825c2b336d">array_stddev</a> (anyarray x)</td></tr> +<tr class="memdesc:a3b6c2d173a611e6d6b184d825c2b336d"><td class="mdescLeft"> </td><td class="mdescRight">This function finds the standard deviation of the values in the array. NULLs are ignored. <a href="#a3b6c2d173a611e6d6b184d825c2b336d">More...</a><br /></td></tr> +<tr class="separator:a3b6c2d173a611e6d6b184d825c2b336d"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:ab066e65a41db78b00b4532996b2a6efc"><td class="memItemLeft" align="right" valign="top">float8 [] </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#ab066e65a41db78b00b4532996b2a6efc">array_of_float</a> (integer k)</td></tr> +<tr class="memdesc:ab066e65a41db78b00b4532996b2a6efc"><td class="mdescLeft"> </td><td class="mdescRight">This function creates an array of set size (the argument value) of FLOAT8, initializing the values to 0.0;. <a href="#ab066e65a41db78b00b4532996b2a6efc">More...</a><br /></td></tr> +<tr class="separator:ab066e65a41db78b00b4532996b2a6efc"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:ab7d8550e66d2e0bd54b8f0997d93880c"><td class="memItemLeft" align="right" valign="top">bigint [] </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#ab7d8550e66d2e0bd54b8f0997d93880c">array_of_bigint</a> (integer k)</td></tr> +<tr class="memdesc:ab7d8550e66d2e0bd54b8f0997d93880c"><td class="mdescLeft"> </td><td class="mdescRight">This function creates an array of set size (the argument value) of BIGINT, initializing the values to 0;. <a href="#ab7d8550e66d2e0bd54b8f0997d93880c">More...</a><br /></td></tr> +<tr class="separator:ab7d8550e66d2e0bd54b8f0997d93880c"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a065a5323f3b742be47e39ad8b4c90fc2"><td class="memItemLeft" align="right" valign="top">anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a065a5323f3b742be47e39ad8b4c90fc2">array_fill</a> (anyarray x, anyelement k)</td></tr> +<tr class="memdesc:a065a5323f3b742be47e39ad8b4c90fc2"><td class="mdescLeft"> </td><td class="mdescRight">This functions set every values in the array to some desired value (provided as the argument). <a href="#a065a5323f3b742be47e39ad8b4c90fc2">More...</a><br /></td></tr> +<tr class="separator:a065a5323f3b742be47e39ad8b4c90fc2"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a8855869bb9f124c3ff5b10041988610c"><td class="memItemLeft" align="right" valign="top">anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a8855869bb9f124c3ff5b10041988610c">array_cos</a> (anyarray x)</td></tr> +<tr class="memdesc:a8855869bb9f124c3ff5b10041988610c"><td class="mdescLeft"> </td><td class="mdescRight">This function takes an array as the input and apply cos function element-wise, returning the resulting array. It requires that all the values are NON-NULL. Return type is the same as the input type. <a href="#a8855869bb9f124c3ff5b10041988610c">More...</a><br /></td></tr> +<tr class="separator:a8855869bb9f124c3ff5b10041988610c"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:ae6881cc5c86941b6ffca35d7f3cd5c12"><td class="memItemLeft" align="right" valign="top">anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#ae6881cc5c86941b6ffca35d7f3cd5c12">array_scalar_mult</a> (anyarray x, anyelement k)</td></tr> +<tr class="memdesc:ae6881cc5c86941b6ffca35d7f3cd5c12"><td class="mdescLeft"> </td><td class="mdescRight">This function takes an array as the input and executes element-wise multiplication by the scalar provided as the second argument, returning the resulting array. It requires that all the values are NON-NULL. Return type is the same as the input type. <a href="#ae6881cc5c86941b6ffca35d7f3cd5c12">More...</a><br /></td></tr> +<tr class="separator:ae6881cc5c86941b6ffca35d7f3cd5c12"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a0b6ffe59b12c3dee076c3059f9ab363f"><td class="memItemLeft" align="right" valign="top">anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a0b6ffe59b12c3dee076c3059f9ab363f">array_scalar_add</a> (anyarray x, anyelement k)</td></tr> +<tr class="memdesc:a0b6ffe59b12c3dee076c3059f9ab363f"><td class="mdescLeft"> </td><td class="mdescRight">This function takes an array as the input and executes element-wise addition by the scalar provided as the second argument, returning the resulting array. It requires that all the values are NON-NULL. Return type is the same as the input type. <a href="#a0b6ffe59b12c3dee076c3059f9ab363f">More...</a><br /></td></tr> +<tr class="separator:a0b6ffe59b12c3dee076c3059f9ab363f"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:acc295a568878940ffc3e2c9a75990efb"><td class="memItemLeft" align="right" valign="top">anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#acc295a568878940ffc3e2c9a75990efb">array_filter</a> (anyarray x, anyelement k, text op)</td></tr> +<tr class="memdesc:acc295a568878940ffc3e2c9a75990efb"><td class="mdescLeft"> </td><td class="mdescRight">This function takes an array as the input and keep only elements that satisfy the operator on specified scalar. It requires that all the values are NON-NULL. Return type is the same as the input type. <a href="#acc295a568878940ffc3e2c9a75990efb">More...</a><br /></td></tr> +<tr class="separator:acc295a568878940ffc3e2c9a75990efb"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a0c3c44e81ff158ce8914258aa5604872"><td class="memItemLeft" align="right" valign="top">anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a0c3c44e81ff158ce8914258aa5604872">array_filter</a> (anyarray x, anyelement k)</td></tr> +<tr class="memdesc:a0c3c44e81ff158ce8914258aa5604872"><td class="mdescLeft"> </td><td class="mdescRight">This function takes an array as the input and removes elements that equal to specified scalar. It requires that all the values are NON-NULL. Return type is the same as the input type. <a href="#a0c3c44e81ff158ce8914258aa5604872">More...</a><br /></td></tr> +<tr class="separator:a0c3c44e81ff158ce8914258aa5604872"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:ac4490f150ecb7aaab0933c223ccde5bd"><td class="memItemLeft" align="right" valign="top">anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#ac4490f150ecb7aaab0933c223ccde5bd">array_filter</a> (anyarray x)</td></tr> +<tr class="memdesc:ac4490f150ecb7aaab0933c223ccde5bd"><td class="mdescLeft"> </td><td class="mdescRight">This function takes an array as the input and removes elements that equal to 0. It requires that all the values are NON-NULL. Return type is the same as the input type. <a href="#ac4490f150ecb7aaab0933c223ccde5bd">More...</a><br /></td></tr> +<tr class="separator:ac4490f150ecb7aaab0933c223ccde5bd"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a83451ed0c3ca5a9c62751dba47e45df7"><td class="memItemLeft" align="right" valign="top">float8 [] </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a83451ed0c3ca5a9c62751dba47e45df7">array_sqrt</a> (anyarray x)</td></tr> +<tr class="memdesc:a83451ed0c3ca5a9c62751dba47e45df7"><td class="mdescLeft"> </td><td class="mdescRight">This function takes an array as the input and finds square root of each element in the array, returning the resulting array. It requires that all the values are NON-NULL. <a href="#a83451ed0c3ca5a9c62751dba47e45df7">More...</a><br /></td></tr> +<tr class="separator:a83451ed0c3ca5a9c62751dba47e45df7"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a761e7ca753a5e1acf26896b37ed8b0bd"><td class="memItemLeft" align="right" valign="top">anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a761e7ca753a5e1acf26896b37ed8b0bd">array_pow</a> (anyarray x, anyelement y)</td></tr> +<tr class="memdesc:a761e7ca753a5e1acf26896b37ed8b0bd"><td class="mdescLeft"> </td><td class="mdescRight">This function takes an array and a float8 as the input and finds power of each element in the array, returning the resulting array. It requires that all the values are NON-NULL. <a href="#a761e7ca753a5e1acf26896b37ed8b0bd">More...</a><br /></td></tr> +<tr class="separator:a761e7ca753a5e1acf26896b37ed8b0bd"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:aff60f4091bed6374683f047c8a70ef9a"><td class="memItemLeft" align="right" valign="top">float8 [] </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#aff60f4091bed6374683f047c8a70ef9a">array_square</a> (anyarray x)</td></tr> +<tr class="memdesc:aff60f4091bed6374683f047c8a70ef9a"><td class="mdescLeft"> </td><td class="mdescRight">This function takes an array as the input and finds square of each element in the array, returning the resulting array. It requires that all the values are NON-NULL. <a href="#aff60f4091bed6374683f047c8a70ef9a">More...</a><br /></td></tr> +<tr class="separator:aff60f4091bed6374683f047c8a70ef9a"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:acb57ea4521dcb717f9e3148e0acccc74"><td class="memItemLeft" align="right" valign="top">float8 [] </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#acb57ea4521dcb717f9e3148e0acccc74">normalize</a> (anyarray x)</td></tr> +<tr class="memdesc:acb57ea4521dcb717f9e3148e0acccc74"><td class="mdescLeft"> </td><td class="mdescRight">This function normalizes an array as sum of squares to be 1. <a href="#acb57ea4521dcb717f9e3148e0acccc74">More...</a><br /></td></tr> +<tr class="separator:acb57ea4521dcb717f9e3148e0acccc74"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a86e48d6f0ed7572cfc10576a07f84d25"><td class="memItemLeft" align="right" valign="top">boolean </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a86e48d6f0ed7572cfc10576a07f84d25">array_contains_null</a> (anyarray x)</td></tr> +<tr class="memdesc:a86e48d6f0ed7572cfc10576a07f84d25"><td class="mdescLeft"> </td><td class="mdescRight">Function to check if array contains NULL. <a href="#a86e48d6f0ed7572cfc10576a07f84d25">More...</a><br /></td></tr> +<tr class="separator:a86e48d6f0ed7572cfc10576a07f84d25"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a819f395ada41a446dd4941f172d0bfef"><td class="memItemLeft" align="right" valign="top">anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a819f395ada41a446dd4941f172d0bfef">array_cum_sum</a> (anyarray x)</td></tr> +<tr class="memdesc:a819f395ada41a446dd4941f172d0bfef"><td class="mdescLeft"> </td><td class="mdescRight">This function takes an array as the input and computes the cumulative sum with the first element being the same. It requires that all the values are NON-NULL. <a href="#a819f395ada41a446dd4941f172d0bfef">More...</a><br /></td></tr> +<tr class="separator:a819f395ada41a446dd4941f172d0bfef"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a69642cec81403897436d3c286bf2b36b"><td class="memItemLeft" align="right" valign="top">anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a69642cec81403897436d3c286bf2b36b">array_cum_prod</a> (anyarray x)</td></tr> +<tr class="memdesc:a69642cec81403897436d3c286bf2b36b"><td class="mdescLeft"> </td><td class="mdescRight">This function takes an array as the input and computes the cumulative product with the first element being the same. It requires that all the values are NON-NULL. <a href="#a69642cec81403897436d3c286bf2b36b">More...</a><br /></td></tr> +<tr class="separator:a69642cec81403897436d3c286bf2b36b"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:af057b589f2a2cb1095caa99feaeb3d70"><td class="memItemLeft" align="right" valign="top">set< record > </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#af057b589f2a2cb1095caa99feaeb3d70">array_unnest_2d_to_1d</a> (anyarray x, int unnest_row_id, anyarray unnest_result)</td></tr> +<tr class="memdesc:af057b589f2a2cb1095caa99feaeb3d70"><td class="mdescLeft"> </td><td class="mdescRight">This function takes a 2-D array as the input and unnests it by one level. It returns a set of 1-D arrays that correspond to rows of the input array as well as an ID column containing row positions occupied by those 1-D arrays within the 2-D array (the ID column values start with 1 and not 0) <a href="#af057b589f2a2cb1095caa99feaeb3d70">More...</a><br /></td></tr> +<tr class="separator:af057b589f2a2cb1095caa99feaeb3d70"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:aa86efceb2ac80f621db00844bab77553"><td class="memItemLeft" align="right" valign="top">text </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#aa86efceb2ac80f621db00844bab77553">array_unnest_2d_to_1d</a> ()</td></tr> +<tr class="separator:aa86efceb2ac80f621db00844bab77553"><td class="memSeparator" colspan="2"> </td></tr> +</table> +<a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2> +<div class="textblock"><dl class="section date"><dt>Date</dt><dd>April 2011 </dd></dl> +</div><h2 class="groupheader">Function Documentation</h2> +<a id="ac14e74c10b58f5518cd0e3e56067e5ba"></a> +<h2 class="memtitle"><span class="permalink"><a href="#ac14e74c10b58f5518cd0e3e56067e5ba">◆ </a></span>array_abs()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyarray array_abs </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Absolute value of all elements of x. </dd></dl> + +</div> +</div> +<a id="a13c0b0c53e8b0dc4e08c21bb8152ee7d"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a13c0b0c53e8b0dc4e08c21bb8152ee7d">◆ </a></span>array_abs_sum()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyelement array_abs_sum </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Sum of absolute value of x </dd></dl> + +</div> +</div> +<a id="a91c8d3715142927b3967f05a4fbf1575"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a91c8d3715142927b3967f05a4fbf1575">◆ </a></span>array_add()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyarray array_add </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>y</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + <tr><td class="paramname">y</td><td>Array y </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Sum of x and y. </dd></dl> + +</div> +</div> +<a id="aedf6cb13eb4803bcc12dc4d95ea8ff4e"></a> +<h2 class="memtitle"><span class="permalink"><a href="#aedf6cb13eb4803bcc12dc4d95ea8ff4e">◆ </a></span>array_contains()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">bool array_contains </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>y</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + <tr><td class="paramname">y</td><td>Array y </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Returns true if x contains y. </dd></dl> + +</div> +</div> +<a id="a86e48d6f0ed7572cfc10576a07f84d25"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a86e48d6f0ed7572cfc10576a07f84d25">◆ </a></span>array_contains_null()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">boolean array_contains_null </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x. </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>True if x has NULL value else False. </dd></dl> + +</div> +</div> +<a id="a8855869bb9f124c3ff5b10041988610c"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a8855869bb9f124c3ff5b10041988610c">◆ </a></span>array_cos()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyarray array_cos </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Array with each element of cos(x). </dd></dl> + +</div> +</div> +<a id="a69642cec81403897436d3c286bf2b36b"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a69642cec81403897436d3c286bf2b36b">◆ </a></span>array_cum_prod()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyarray array_cum_prod </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Cumulative product of the elements in x. </dd></dl> + +</div> +</div> +<a id="a819f395ada41a446dd4941f172d0bfef"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a819f395ada41a446dd4941f172d0bfef">◆ </a></span>array_cum_sum()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyarray array_cum_sum </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Cumulative sum of the elements in x. </dd></dl> + +</div> +</div> +<a id="a6cc05e7052495f8b64692faf40219576"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a6cc05e7052495f8b64692faf40219576">◆ </a></span>array_div()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyarray array_div </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>y</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + <tr><td class="paramname">y</td><td>Array y </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Element-wise division of x and y. </dd></dl> + +</div> +</div> +<a id="acde10964ed23b7c8da515fb84cb8d5e0"></a> +<h2 class="memtitle"><span class="permalink"><a href="#acde10964ed23b7c8da515fb84cb8d5e0">◆ </a></span>array_dot()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">float8 array_dot </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>y</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + <tr><td class="paramname">y</td><td>Array y </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Dot-product of x and y. </dd></dl> + +</div> +</div> +<a id="a065a5323f3b742be47e39ad8b4c90fc2"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a065a5323f3b742be47e39ad8b4c90fc2">◆ </a></span>array_fill()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyarray array_fill </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">anyelement </td> + <td class="paramname"><em>k</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Some array </td></tr> + <tr><td class="paramname">k</td><td>Desired value </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Fills array with desired value. </dd></dl> + +</div> +</div> +<a id="acc295a568878940ffc3e2c9a75990efb"></a> +<h2 class="memtitle"><span class="permalink"><a href="#acc295a568878940ffc3e2c9a75990efb">◆ </a></span>array_filter() <span class="overload">[1/3]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyarray array_filter </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">anyelement </td> + <td class="paramname"><em>k</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>op</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + <tr><td class="paramname">k</td><td>Scalar </td></tr> + <tr><td class="paramname">op</td><td>Operator </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Filtered array. </dd></dl> + +</div> +</div> +<a id="a0c3c44e81ff158ce8914258aa5604872"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a0c3c44e81ff158ce8914258aa5604872">◆ </a></span>array_filter() <span class="overload">[2/3]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyarray array_filter </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">anyelement </td> + <td class="paramname"><em>k</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + <tr><td class="paramname">k</td><td>Scalar </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Filtered array. </dd></dl> + +</div> +</div> +<a id="ac4490f150ecb7aaab0933c223ccde5bd"></a> +<h2 class="memtitle"><span class="permalink"><a href="#ac4490f150ecb7aaab0933c223ccde5bd">◆ </a></span>array_filter() <span class="overload">[3/3]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyarray array_filter </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Filtered array. </dd></dl> + +</div> +</div> +<a id="ae891429cc50705c530f3e5ca15541849"></a> +<h2 class="memtitle"><span class="permalink"><a href="#ae891429cc50705c530f3e5ca15541849">◆ </a></span>array_max()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyelement array_max </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Max of x. </dd></dl> + +</div> +</div> +<a id="aa415256a9064aecc600dfb5e377fb7b1"></a> +<h2 class="memtitle"><span class="permalink"><a href="#aa415256a9064aecc600dfb5e377fb7b1">◆ </a></span>array_max_index()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">float8 [] array_max_index </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Array as [max, index]. </dd></dl> + +</div> +</div> +<a id="a407598f9eb70637798b02fd731bfca2c"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a407598f9eb70637798b02fd731bfca2c">◆ </a></span>array_mean()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">float8 array_mean </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Mean of x. </dd></dl> + +</div> +</div> +<a id="a6659bf9d9363eb179fab34f81f8ac59b"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a6659bf9d9363eb179fab34f81f8ac59b">◆ </a></span>array_min()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyelement array_min </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Min of x. </dd></dl> + +</div> +</div> +<a id="a813a4d9ffc1c18b1b3e18f6ecdb2051f"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a813a4d9ffc1c18b1b3e18f6ecdb2051f">◆ </a></span>array_min_index()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">float8 [] array_min_index </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Array as [min, index]. </dd></dl> + +</div> +</div> +<a id="a652d70c480d484c4a1a92ded384b0dd7"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a652d70c480d484c4a1a92ded384b0dd7">◆ </a></span>array_mult()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyarray array_mult </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>y</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + <tr><td class="paramname">y</td><td>Array y </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Element-wise product of x and y. </dd></dl> + +</div> +</div> +<a id="ab7d8550e66d2e0bd54b8f0997d93880c"></a> +<h2 class="memtitle"><span class="permalink"><a href="#ab7d8550e66d2e0bd54b8f0997d93880c">◆ </a></span>array_of_bigint()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">bigint [] array_of_bigint </td> + <td>(</td> + <td class="paramtype">integer </td> + <td class="paramname"><em>k</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">k</td><td>Array size. </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Array of size k. </dd></dl> + +</div> +</div> +<a id="ab066e65a41db78b00b4532996b2a6efc"></a> +<h2 class="memtitle"><span class="permalink"><a href="#ab066e65a41db78b00b4532996b2a6efc">◆ </a></span>array_of_float()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">float8 [] array_of_float </td> + <td>(</td> + <td class="paramtype">integer </td> + <td class="paramname"><em>k</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">k</td><td>Array size </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Array of size k. </dd></dl> + +</div> +</div> +<a id="a761e7ca753a5e1acf26896b37ed8b0bd"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a761e7ca753a5e1acf26896b37ed8b0bd">◆ </a></span>array_pow()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyarray array_pow </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">anyelement </td> + <td class="paramname"><em>y</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + <tr><td class="paramname">y</td><td>Desired power </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Power of y for all elements of x. </dd></dl> + +</div> +</div> +<a id="a0b6ffe59b12c3dee076c3059f9ab363f"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a0b6ffe59b12c3dee076c3059f9ab363f">◆ </a></span>array_scalar_add()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyarray array_scalar_add </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">anyelement </td> + <td class="paramname"><em>k</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + <tr><td class="paramname">k</td><td>Scalar </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Array with each element of x added by scalar. </dd></dl> + +</div> +</div> +<a id="ae6881cc5c86941b6ffca35d7f3cd5c12"></a> +<h2 class="memtitle"><span class="permalink"><a href="#ae6881cc5c86941b6ffca35d7f3cd5c12">◆ </a></span>array_scalar_mult()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyarray array_scalar_mult </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">anyelement </td> + <td class="paramname"><em>k</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + <tr><td class="paramname">k</td><td>Scalar </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Array with each element of x multiplied by scalar. </dd></dl> + +</div> +</div> +<a id="a83451ed0c3ca5a9c62751dba47e45df7"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a83451ed0c3ca5a9c62751dba47e45df7">◆ </a></span>array_sqrt()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">float8 [] array_sqrt </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Square root of all elements of x. </dd></dl> + +</div> +</div> +<a id="aff60f4091bed6374683f047c8a70ef9a"></a> +<h2 class="memtitle"><span class="permalink"><a href="#aff60f4091bed6374683f047c8a70ef9a">◆ </a></span>array_square()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">float8 [] array_square </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Square of all elements of x. </dd></dl> + +</div> +</div> +<a id="a3b6c2d173a611e6d6b184d825c2b336d"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a3b6c2d173a611e6d6b184d825c2b336d">◆ </a></span>array_stddev()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">float8 array_stddev </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Standard deviation of x. </dd></dl> + +</div> +</div> +<a id="a2875a161a01c7dcdea9a4997b074eefc"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a2875a161a01c7dcdea9a4997b074eefc">◆ </a></span>array_sub()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyarray array_sub </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>y</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + <tr><td class="paramname">y</td><td>Array y </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>x-y. </dd></dl> + +</div> +</div> +<a id="a4c98f20e6a737358806f63318daea5ec"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a4c98f20e6a737358806f63318daea5ec">◆ </a></span>array_sum()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">anyelement array_sum </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Sum of x. </dd></dl> + +</div> +</div> +<a id="a418de59800833aa95f9b7cbd6b12901c"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a418de59800833aa95f9b7cbd6b12901c">◆ </a></span>array_sum_big()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">float8 array_sum_big </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Sum of x. </dd></dl> + +</div> +</div> +<a id="af057b589f2a2cb1095caa99feaeb3d70"></a> +<h2 class="memtitle"><span class="permalink"><a href="#af057b589f2a2cb1095caa99feaeb3d70">◆ </a></span>array_unnest_2d_to_1d() <span class="overload">[1/2]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">set<record> array_unnest_2d_to_1d </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">int </td> + <td class="paramname"><em>unnest_row_id</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>unnest_result</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Set of 1-D arrays that corrspond to rows of x and an ID column. </dd></dl> + +</div> +</div> +<a id="aa86efceb2ac80f621db00844bab77553"></a> +<h2 class="memtitle"><span class="permalink"><a href="#aa86efceb2ac80f621db00844bab77553">◆ </a></span>array_unnest_2d_to_1d() <span class="overload">[2/2]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">text array_unnest_2d_to_1d </td> + <td>(</td> + <td class="paramname"></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="acb57ea4521dcb717f9e3148e0acccc74"></a> +<h2 class="memtitle"><span class="permalink"><a href="#acb57ea4521dcb717f9e3148e0acccc74">◆ </a></span>normalize()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">float8 [] normalize </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"><em>x</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x. </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Array normalized by its 2-norm. </dd></dl> + +</div> +</div> +<a id="a26e8508a2bae10a6574cec697a270eea"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a26e8508a2bae10a6574cec697a270eea">◆ </a></span>sum()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">aggregate anyarray sum </td> + <td>(</td> + <td class="paramtype">anyarray </td> + <td class="paramname"></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">x</td><td>Array x </td></tr> + <tr><td class="paramname">y</td><td>Array y </td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>Sum of x and y. </dd></dl> + +</div> +</div> +</div><!-- contents --> +</div><!-- doc-content --> +<!-- start footer part --> +<div id="nav-path" class="navpath"><!-- id is needed for treeview function! --> + <ul> + <li class="navelem"><a class="el" href="dir_5782bb6b417390b9b62f39df14784c0c.html">incubator-madlib</a></li><li class="navelem"><a class="el" href="dir_93241c6f02785cda96cb2a5453b16091.html">methods</a></li><li class="navelem"><a class="el" href="dir_a3ac5584feaaa1368115abd5f91b8e22.html">array_ops</a></li><li class="navelem"><a class="el" href="dir_a84a9848deb14f7db801b07ed9e6c67a.html">src</a></li><li class="navelem"><a class="el" href="dir_236d722cd8d4ab3240cfd6a99711293a.html">pg_gp</a></li><li class="navelem"><a class="el" href="array__ops_8sql__in.html">array_ops.sql_in</a></li> + <li class="footer">Generated on Tue May 16 2017 13:24:38 for MADlib by + <a href="http://www.doxygen.org/index.html";> + <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.13 </li> + </ul> +</div> +</body> +</html>
http://git-wip-us.apache.org/repos/asf/incubator-madlib-site/blob/b5b51c69/docs/v1.11/assoc__rules_8sql__in.html ---------------------------------------------------------------------- diff --git a/docs/v1.11/assoc__rules_8sql__in.html b/docs/v1.11/assoc__rules_8sql__in.html new file mode 100644 index 0000000..ab5ba77 --- /dev/null +++ b/docs/v1.11/assoc__rules_8sql__in.html @@ -0,0 +1,402 @@ +<!-- HTML header for doxygen 1.8.4--> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> +<html xmlns="http://www.w3.org/1999/xhtml";> +<head> +<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/> +<meta http-equiv="X-UA-Compatible" content="IE=9"/> +<meta name="generator" content="Doxygen 1.8.13"/> +<meta name="keywords" content="madlib,postgres,greenplum,machine learning,data mining,deep learning,ensemble methods,data science,market basket analysis,affinity analysis,pca,lda,regression,elastic net,huber white,proportional hazards,k-means,latent dirichlet allocation,bayes,support vector machines,svm"/> +<title>MADlib: assoc_rules.sql_in File Reference</title> +<link href="tabs.css" rel="stylesheet" type="text/css"/> +<script type="text/javascript" src="jquery.js"></script> +<script type="text/javascript" src="dynsections.js"></script> +<link href="navtree.css" rel="stylesheet" type="text/css"/> +<script type="text/javascript" src="resize.js"></script> +<script type="text/javascript" src="navtreedata.js"></script> +<script type="text/javascript" src="navtree.js"></script> +<script type="text/javascript"> + $(document).ready(initResizable); +</script> +<link href="search/search.css" rel="stylesheet" type="text/css"/> +<script type="text/javascript" src="search/searchdata.js"></script> +<script type="text/javascript" src="search/search.js"></script> +<script type="text/javascript"> + $(document).ready(function() { init_search(); }); +</script> +<!-- hack in the navigation tree --> +<script type="text/javascript" src="eigen_navtree_hacks.js"></script> +<link href="doxygen.css" rel="stylesheet" type="text/css" /> +<link href="madlib_extra.css" rel="stylesheet" type="text/css"/> +<!-- google analytics --> +<script> + (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ + (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), + m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) + })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); + ga('create', 'UA-45382226-1', 'madlib.incubator.apache.org'); + ga('send', 'pageview'); +</script> +</head> +<body> +<div id="top"><!-- do not remove this div, it is closed by doxygen! --> +<div id="titlearea"> +<table cellspacing="0" cellpadding="0"> + <tbody> + <tr style="height: 56px;"> + <td id="projectlogo"><a href="http://madlib.incubator.apache.org";><img alt="Logo" src="madlib.png" height="50" style="padding-left:0.5em;" border="0"/ ></a></td> + <td style="padding-left: 0.5em;"> + <div id="projectname"> + <span id="projectnumber">1.11</span> + </div> + <div id="projectbrief">User Documentation for MADlib</div> + </td> + <td> <div id="MSearchBox" class="MSearchBoxInactive"> + <span class="left"> + <img id="MSearchSelect" src="search/mag_sel.png" + onmouseover="return searchBox.OnSearchSelectShow()" + onmouseout="return searchBox.OnSearchSelectHide()" + alt=""/> + <input type="text" id="MSearchField" value="Search" accesskey="S" + onfocus="searchBox.OnSearchFieldFocus(true)" + onblur="searchBox.OnSearchFieldFocus(false)" + onkeyup="searchBox.OnSearchFieldChange(event)"/> + </span><span class="right"> + <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a> + </span> + </div> +</td> + </tr> + </tbody> +</table> +</div> +<!-- end header part --> +<!-- Generated by Doxygen 1.8.13 --> +<script type="text/javascript"> +var searchBox = new SearchBox("searchBox", "search",false,'Search'); +</script> +</div><!-- top --> +<div id="side-nav" class="ui-resizable side-nav-resizable"> + <div id="nav-tree"> + <div id="nav-tree-contents"> + <div id="nav-sync" class="sync"></div> + </div> + </div> + <div id="splitbar" style="-moz-user-select:none;" + class="ui-resizable-handle"> + </div> +</div> +<script type="text/javascript"> +$(document).ready(function(){initNavTree('assoc__rules_8sql__in.html','');}); +</script> +<div id="doc-content"> +<!-- window showing the filter options --> +<div id="MSearchSelectWindow" + onmouseover="return searchBox.OnSearchSelectShow()" + onmouseout="return searchBox.OnSearchSelectHide()" + onkeydown="return searchBox.OnSearchSelectKey(event)"> +</div> + +<!-- iframe showing the search results (closed by default) --> +<div id="MSearchResultsWindow"> +<iframe src="javascript:void(0)" frameborder="0" + name="MSearchResults" id="MSearchResults"> +</iframe> +</div> + +<div class="header"> + <div class="summary"> +<a href="#func-members">Functions</a> </div> + <div class="headertitle"> +<div class="title">assoc_rules.sql_in File Reference</div> </div> +</div><!--header--> +<div class="contents"> + +<p>The <a class="el" href="assoc__rules_8sql__in.html#a8362eb54bb0eeb551d5a1aadb96e7092">assoc_rules</a> function computes association rules for a given set of data. The data is assumed to have two dimensions; items (between which we are trying to discover associations), and a transaction id. This tranaction id groups the items by event and could also be a user id, date, etc. depending on the context of the data. This function assumes the data is stored in two columns with one transaction id and one item per row. +<a href="#details">More...</a></p> +<table class="memberdecls"> +<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="func-members"></a> +Functions</h2></td></tr> +<tr class="memitem:a9a872579615586ce478d32ba145cc279"><td class="memItemLeft" align="right" valign="top">set< text[]> </td><td class="memItemRight" valign="bottom"><a class="el" href="assoc__rules_8sql__in.html#a9a872579615586ce478d32ba145cc279">gen_rules_from_cfp</a> (text, int)</td></tr> +<tr class="separator:a9a872579615586ce478d32ba145cc279"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a2ce0222d57332da628eb98220130e905"><td class="memItemLeft" align="right" valign="top">assoc_rules_results </td><td class="memItemRight" valign="bottom"><a class="el" href="assoc__rules_8sql__in.html#a2ce0222d57332da628eb98220130e905">assoc_rules</a> (float8 support, float8 confidence, text tid_col, text item_col, text input_table, text output_schema, boolean verbose, integer max_itemset_size)</td></tr> +<tr class="separator:a2ce0222d57332da628eb98220130e905"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a68a256d98b82ac15bac7df92e806f6f8"><td class="memItemLeft" align="right" valign="top">assoc_rules_results </td><td class="memItemRight" valign="bottom"><a class="el" href="assoc__rules_8sql__in.html#a68a256d98b82ac15bac7df92e806f6f8">assoc_rules</a> (float8 support, float8 confidence, text tid_col, text item_col, text input_table, text output_schema)</td></tr> +<tr class="memdesc:a68a256d98b82ac15bac7df92e806f6f8"><td class="mdescLeft"> </td><td class="mdescRight">The short form of the above function with vobose removed. <a href="#a68a256d98b82ac15bac7df92e806f6f8">More...</a><br /></td></tr> +<tr class="separator:a68a256d98b82ac15bac7df92e806f6f8"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:af9456adb6dad01e452415b9a0a5371dc"><td class="memItemLeft" align="right" valign="top">assoc_rules_results </td><td class="memItemRight" valign="bottom"><a class="el" href="assoc__rules_8sql__in.html#af9456adb6dad01e452415b9a0a5371dc">assoc_rules</a> (float8 support, float8 confidence, text tid_col, text item_col, text input_table, text output_schema, boolean verbose)</td></tr> +<tr class="separator:af9456adb6dad01e452415b9a0a5371dc"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:aeddb752c12b9af779d796b135f900e38"><td class="memItemLeft" align="right" valign="top">text </td><td class="memItemRight" valign="bottom"><a class="el" href="assoc__rules_8sql__in.html#aeddb752c12b9af779d796b135f900e38">assoc_rules</a> (text message)</td></tr> +<tr class="separator:aeddb752c12b9af779d796b135f900e38"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a8362eb54bb0eeb551d5a1aadb96e7092"><td class="memItemLeft" align="right" valign="top">text </td><td class="memItemRight" valign="bottom"><a class="el" href="assoc__rules_8sql__in.html#a8362eb54bb0eeb551d5a1aadb96e7092">assoc_rules</a> ()</td></tr> +<tr class="separator:a8362eb54bb0eeb551d5a1aadb96e7092"><td class="memSeparator" colspan="2"> </td></tr> +</table> +<a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2> +<div class="textblock"><dl class="section date"><dt>Date</dt><dd>June 2011 </dd> +<dd> +August 2012</dd></dl> +<dl class="section see"><dt>See also</dt><dd>For a brief introduction to the association rules implementation, see the module description <a class="el" href="group__grp__assoc__rules.html">Apriori Algorithm</a>. </dd></dl> +</div><h2 class="groupheader">Function Documentation</h2> +<a id="a2ce0222d57332da628eb98220130e905"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a2ce0222d57332da628eb98220130e905">◆ </a></span>assoc_rules() <span class="overload">[1/5]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">assoc_rules_results assoc_rules </td> + <td>(</td> + <td class="paramtype">float8 </td> + <td class="paramname"><em>support</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">float8 </td> + <td class="paramname"><em>confidence</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>tid_col</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>item_col</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>input_table</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>output_schema</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">boolean </td> + <td class="paramname"><em>verbose</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"><em>max_itemset_size</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">support</td><td>minimum level of support needed for each itemset to be included in result </td></tr> + <tr><td class="paramname">confidence</td><td>minimum level of confidence needed for each rule to be included in result </td></tr> + <tr><td class="paramname">tid_col</td><td>name of the column storing the transaction ids </td></tr> + <tr><td class="paramname">item_col</td><td>name of the column storing the products </td></tr> + <tr><td class="paramname">input_table</td><td>name of the table where the data is stored </td></tr> + <tr><td class="paramname">output_schema</td><td>name of the schema where the final results will be stored </td></tr> + <tr><td class="paramname">verbose</td><td>determining if output contains comments</td></tr> + </table> + </dd> +</dl> +<dl class="section return"><dt>Returns</dt><dd>The schema and table name containing association rules, and total number of rules found.</dd></dl> +<p>This function computes the association rules between products in a data set. It reads the name of the table, the column names of the product and ids, and computes ssociation rules using the Apriori algorithm, and subject to the support and confidence constraints as input by the user. This version of association rules has verbose functionality. When verbose is true, output of function includes iteration steps and comments on Apriori algorithm steps. </p> + +</div> +</div> +<a id="a68a256d98b82ac15bac7df92e806f6f8"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a68a256d98b82ac15bac7df92e806f6f8">◆ </a></span>assoc_rules() <span class="overload">[2/5]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">assoc_rules_results assoc_rules </td> + <td>(</td> + <td class="paramtype">float8 </td> + <td class="paramname"><em>support</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">float8 </td> + <td class="paramname"><em>confidence</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>tid_col</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>item_col</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>input_table</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>output_schema</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="af9456adb6dad01e452415b9a0a5371dc"></a> +<h2 class="memtitle"><span class="permalink"><a href="#af9456adb6dad01e452415b9a0a5371dc">◆ </a></span>assoc_rules() <span class="overload">[3/5]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">assoc_rules_results assoc_rules </td> + <td>(</td> + <td class="paramtype">float8 </td> + <td class="paramname"><em>support</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">float8 </td> + <td class="paramname"><em>confidence</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>tid_col</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>item_col</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>input_table</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>output_schema</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">boolean </td> + <td class="paramname"><em>verbose</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="aeddb752c12b9af779d796b135f900e38"></a> +<h2 class="memtitle"><span class="permalink"><a href="#aeddb752c12b9af779d796b135f900e38">◆ </a></span>assoc_rules() <span class="overload">[4/5]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">text assoc_rules </td> + <td>(</td> + <td class="paramtype">text </td> + <td class="paramname"><em>message</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a8362eb54bb0eeb551d5a1aadb96e7092"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a8362eb54bb0eeb551d5a1aadb96e7092">◆ </a></span>assoc_rules() <span class="overload">[5/5]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">text assoc_rules </td> + <td>(</td> + <td class="paramname"></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a9a872579615586ce478d32ba145cc279"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a9a872579615586ce478d32ba145cc279">◆ </a></span>gen_rules_from_cfp()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">set<text[]> gen_rules_from_cfp </td> + <td>(</td> + <td class="paramtype">text </td> + <td class="paramname">, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">int </td> + <td class="paramname"> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +</div><!-- contents --> +</div><!-- doc-content --> +<!-- start footer part --> +<div id="nav-path" class="navpath"><!-- id is needed for treeview function! --> + <ul> + <li class="navelem"><a class="el" href="dir_5782bb6b417390b9b62f39df14784c0c.html">incubator-madlib</a></li><li class="navelem"><a class="el" href="dir_b6a04cbbf19cfc3536564b9928d4f3dc.html">src</a></li><li class="navelem"><a class="el" href="dir_71a41f8b7207fbbc465a4e4d95589314.html">ports</a></li><li class="navelem"><a class="el" href="dir_bae1ff22d939d9eb42c7df1d0670bc94.html">postgres</a></li><li class="navelem"><a class="el" href="dir_4ce76aedc0a361354a0cdf298ef8a21b.html">modules</a></li><li class="navelem"><a class="el" href="dir_e3c5a88cb45d2230a8fc199a8110e02f.html">assoc_rules</a></li><li class="navelem"><a class="el" href="assoc__rules_8sql__in.html">assoc_rules.sql_in</a></li> + <li class="footer">Generated on Tue May 16 2017 13:24:38 for MADlib by + <a href="http://www.doxygen.org/index.html";> + <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.13 </li> + </ul> +</div> +</body> +</html>
