| <!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.4"/> |
| <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="navtree.js"></script> |
| <script type="text/javascript"> |
| $(document).ready(initResizable); |
| $(window).load(resizeHeight); |
| </script> |
| <link href="search/search.css" rel="stylesheet" type="text/css"/> |
| <script type="text/javascript" src="search/search.js"></script> |
| <script type="text/javascript"> |
| $(document).ready(function() { searchBox.OnSelectItem(0); }); |
| </script> |
| <script type="text/x-mathjax-config"> |
| MathJax.Hub.Config({ |
| extensions: ["tex2jax.js", "TeX/AMSmath.js", "TeX/AMSsymbols.js"], |
| jax: ["input/TeX","output/HTML-CSS"], |
| }); |
| </script><script src="../mathjax/MathJax.js"></script> |
| <link href="doxygen.css" rel="stylesheet" type="text/css" /> |
| </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 style="padding-left: 0.5em;"> |
| <div id="projectname">MADlib |
|  <span id="projectnumber">1.0</span> <span style="font-size:10pt; font-style:italic"><a href="../latest/./array__ops_8sql__in.html"> A newer version is available</a></span> |
| </div> |
| <div id="projectbrief">User Documentation</div> |
| </td> |
| </tr> |
| </tbody> |
| </table> |
| </div> |
| <!-- end header part --> |
| <!-- Generated by Doxygen 1.8.4 --> |
| <script type="text/javascript"> |
| var searchBox = new SearchBox("searchBox", "search",false,'Search'); |
| </script> |
| <div id="navrow1" class="tabs"> |
| <ul class="tablist"> |
| <li><a href="index.html"><span>Main Page</span></a></li> |
| <li><a href="modules.html"><span>Modules</span></a></li> |
| <li> |
| <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> |
| </li> |
| </ul> |
| </div> |
| </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)"> |
| <a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark"> </span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark"> </span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark"> </span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark"> </span>Groups</a></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> |
| |
| <p><a href="array__ops_8sql__in_source.html">Go to the source code of this file.</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: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. <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: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: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 array_sum in the cases when sum may overflow the array type. <a href="#a418de59800833aa95f9b7cbd6b12901c">More...</a><br/></td></tr> |
| <tr class="separator:a418de59800833aa95f9b7cbd6b12901c"><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">TThis function finds the mean of the values in the array. NULLs are ignored. Return type is the same as the input type. <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. Return type is the same as the input type. <a href="#a3b6c2d173a611e6d6b184d825c2b336d">More...</a><br/></td></tr> |
| <tr class="separator:a3b6c2d173a611e6d6b184d825c2b336d"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a2c42a29f01aeab521073bb329fa4d239"><td class="memItemLeft" align="right" valign="top">float8[] </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a2c42a29f01aeab521073bb329fa4d239">array_of_float</a> (int4 k)</td></tr> |
| <tr class="memdesc:a2c42a29f01aeab521073bb329fa4d239"><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="#a2c42a29f01aeab521073bb329fa4d239">More...</a><br/></td></tr> |
| <tr class="separator:a2c42a29f01aeab521073bb329fa4d239"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:a4b562ee8fb5b3f974fdc56093c0cc9dd"><td class="memItemLeft" align="right" valign="top">int8[] </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a4b562ee8fb5b3f974fdc56093c0cc9dd">array_of_bigint</a> (int4 k)</td></tr> |
| <tr class="memdesc:a4b562ee8fb5b3f974fdc56093c0cc9dd"><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="#a4b562ee8fb5b3f974fdc56093c0cc9dd">More...</a><br/></td></tr> |
| <tr class="separator:a4b562ee8fb5b3f974fdc56093c0cc9dd"><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: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 with 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:a66195b7521ba0491f7fcbb54b10f335d"><td class="memItemLeft" align="right" valign="top">anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#a66195b7521ba0491f7fcbb54b10f335d">array_sqrt</a> (anyarray x)</td></tr> |
| <tr class="memdesc:a66195b7521ba0491f7fcbb54b10f335d"><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. Return type is the same as the input type. This means that if the input if of the size INT, the results would also be rounded. <a href="#a66195b7521ba0491f7fcbb54b10f335d">More...</a><br/></td></tr> |
| <tr class="separator:a66195b7521ba0491f7fcbb54b10f335d"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:adf90038b728d1904b03767cc79dd9561"><td class="memItemLeft" align="right" valign="top">float8[] </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#adf90038b728d1904b03767cc79dd9561">normalize</a> (float8[] x)</td></tr> |
| <tr class="memdesc:adf90038b728d1904b03767cc79dd9561"><td class="mdescLeft"> </td><td class="mdescRight">Array normalization function. <a href="#adf90038b728d1904b03767cc79dd9561">More...</a><br/></td></tr> |
| <tr class="separator:adf90038b728d1904b03767cc79dd9561"><td class="memSeparator" colspan="2"> </td></tr> |
| <tr class="memitem:af9f60293134ba4ce05b1f97f6faba822"><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="af9f60293134ba4ce05b1f97f6faba822"></a> |
| aggregate anyarray </td><td class="memItemRight" valign="bottom"><a class="el" href="array__ops_8sql__in.html#af9f60293134ba4ce05b1f97f6faba822">array_agg</a> (anyelement)</td></tr> |
| <tr class="memdesc:af9f60293134ba4ce05b1f97f6faba822"><td class="mdescLeft"> </td><td class="mdescRight">ARRAY_AGG aggregate for compatibility with GPDB < 4.1 and Postgres < 9.0 This is a slower solution than the built in array_agg that appears in later GPDB and Postgres versions. <br/></td></tr> |
| <tr class="separator:af9f60293134ba4ce05b1f97f6faba822"><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> |
| |
| <p>Definition in file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| </div><h2 class="groupheader">Function Documentation</h2> |
| <a class="anchor" id="a91c8d3715142927b3967f05a4fbf1575"></a> |
| <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> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00067">67</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </div> |
| </div> |
| <a class="anchor" id="aedf6cb13eb4803bcc12dc4d95ea8ff4e"></a> |
| <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> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00127">127</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </div> |
| </div> |
| <a class="anchor" id="a6cc05e7052495f8b64692faf40219576"></a> |
| <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> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00103">103</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </div> |
| </div> |
| <a class="anchor" id="acde10964ed23b7c8da515fb84cb8d5e0"></a> |
| <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> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00115">115</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </div> |
| </div> |
| <a class="anchor" id="a065a5323f3b742be47e39ad8b4c90fc2"></a> |
| <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> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00227">227</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </div> |
| </div> |
| <a class="anchor" id="ae891429cc50705c530f3e5ca15541849"></a> |
| <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> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00138">138</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </div> |
| </div> |
| <a class="anchor" id="a407598f9eb70637798b02fd731bfca2c"></a> |
| <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> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00182">182</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </div> |
| </div> |
| <a class="anchor" id="a6659bf9d9363eb179fab34f81f8ac59b"></a> |
| <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> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00149">149</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </div> |
| </div> |
| <a class="anchor" id="a652d70c480d484c4a1a92ded384b0dd7"></a> |
| <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> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00091">91</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </div> |
| </div> |
| <a class="anchor" id="a4b562ee8fb5b3f974fdc56093c0cc9dd"></a> |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">int8 [] array_of_bigint </td> |
| <td>(</td> |
| <td class="paramtype">int4 </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> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00215">215</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </div> |
| </div> |
| <a class="anchor" id="a2c42a29f01aeab521073bb329fa4d239"></a> |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 [] array_of_float </td> |
| <td>(</td> |
| <td class="paramtype">int4 </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> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00204">204</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </div> |
| </div> |
| <a class="anchor" id="ae6881cc5c86941b6ffca35d7f3cd5c12"></a> |
| <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> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00238">238</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </div> |
| </div> |
| <a class="anchor" id="a66195b7521ba0491f7fcbb54b10f335d"></a> |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">anyarray 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> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00249">249</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </div> |
| </div> |
| <a class="anchor" id="a3b6c2d173a611e6d6b184d825c2b336d"></a> |
| <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> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00193">193</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </div> |
| </div> |
| <a class="anchor" id="a2875a161a01c7dcdea9a4997b074eefc"></a> |
| <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> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00079">79</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </div> |
| </div> |
| <a class="anchor" id="a4c98f20e6a737358806f63318daea5ec"></a> |
| <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> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00160">160</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </div> |
| </div> |
| <a class="anchor" id="a418de59800833aa95f9b7cbd6b12901c"></a> |
| <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> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00171">171</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </div> |
| </div> |
| <a class="anchor" id="adf90038b728d1904b03767cc79dd9561"></a> |
| <div class="memitem"> |
| <div class="memproto"> |
| <table class="memname"> |
| <tr> |
| <td class="memname">float8 [] normalize </td> |
| <td>(</td> |
| <td class="paramtype">float8[] </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 norm. </dd></dl> |
| |
| <p>Definition at line <a class="el" href="array__ops_8sql__in_source.html#l00261">261</a> of file <a class="el" href="array__ops_8sql__in_source.html">array_ops.sql_in</a>.</p> |
| |
| </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_704eb8350b43e1ca74c0f90ed1ba450e.html">methods</a></li><li class="navelem"><a class="el" href="dir_834e55cf992733df24fbe86b49356157.html">array_ops</a></li><li class="navelem"><a class="el" href="dir_c8a9890f716ab6621b63d44c36a168eb.html">src</a></li><li class="navelem"><a class="el" href="dir_fe647384fff178c2cff5ce75fb4044e5.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 Sep 10 2013 15:48:04 for MADlib by |
| <a href="http://www.doxygen.org/index.html"> |
| <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.4 </li> |
| </ul> |
| </div> |
| </body> |
| </html> |
