| <!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"/> |
| <title>MADlib: array_ops.sql_in File Reference</title> |
| |
| <link href="tabs.css" rel="stylesheet" type="text/css"/> |
| <link href="doxygen.css" rel="stylesheet" type="text/css" /> |
| <link href="navtree.css" rel="stylesheet" type="text/css"/> |
| <script type="text/javascript" src="jquery.js"></script> |
| <script type="text/javascript" src="resize.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/search.js"></script> |
| <script type="text/javascript"> |
| $(document).ready(function() { searchBox.OnSelectItem(0); }); |
| </script> |
| <script src="../mathjax/MathJax.js"> |
| MathJax.Hub.Config({ |
| extensions: ["tex2jax.js", "TeX/AMSmath.js", "TeX/AMSsymbols.js"], |
| jax: ["input/TeX","output/HTML-CSS"], |
| }); |
| </script> |
| </head> |
| <body> |
| <div id="top"><!-- do not remove this div! --> |
| |
| |
| <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">0.6</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> |
| |
| <!-- Generated by Doxygen 1.7.5.1 --> |
| <script type="text/javascript"> |
| var searchBox = new SearchBox("searchBox", "search",false,'Search'); |
| </script> |
| <script type="text/javascript" src="dynsections.js"></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 class="current"><a href="files.html"><span>Files</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 id="navrow2" class="tabs2"> |
| <ul class="tablist"> |
| <li><a href="files.html"><span>File List</span></a></li> |
| <li><a href="globals.html"><span>File Members</span></a></li> |
| </ul> |
| </div> |
| </div> |
| <div id="side-nav" class="ui-resizable side-nav-resizable"> |
| <div id="nav-tree"> |
| <div id="nav-tree-contents"> |
| </div> |
| </div> |
| <div id="splitbar" style="-moz-user-select:none;" |
| class="ui-resizable-handle"> |
| </div> |
| </div> |
| <script type="text/javascript"> |
| initNavTree('array__ops_8sql__in.html',''); |
| </script> |
| <div id="doc-content"> |
| <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> |
| <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><td colspan="2"><h2><a name="func-members"></a> |
| Functions</h2></td></tr> |
| <tr><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><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"></a><br/></td></tr> |
| <tr><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><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"></a><br/></td></tr> |
| <tr><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><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"></a><br/></td></tr> |
| <tr><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><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"></a><br/></td></tr> |
| <tr><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><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"></a><br/></td></tr> |
| <tr><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><td class="mdescLeft"> </td><td class="mdescRight">Checks whether one array contains the other. <a href="#aedf6cb13eb4803bcc12dc4d95ea8ff4e"></a><br/></td></tr> |
| <tr><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><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"></a><br/></td></tr> |
| <tr><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><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"></a><br/></td></tr> |
| <tr><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><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"></a><br/></td></tr> |
| <tr><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><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"></a><br/></td></tr> |
| <tr><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><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"></a><br/></td></tr> |
| <tr><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><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"></a><br/></td></tr> |
| <tr><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><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"></a><br/></td></tr> |
| <tr><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><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"></a><br/></td></tr> |
| <tr><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><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"></a><br/></td></tr> |
| <tr><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><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"></a><br/></td></tr> |
| <tr><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><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"></a><br/></td></tr> |
| <tr><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><td class="mdescLeft"> </td><td class="mdescRight">Array normalization function. <a href="#adf90038b728d1904b03767cc79dd9561"></a><br/></td></tr> |
| <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="af9f60293134ba4ce05b1f97f6faba822"></a><!-- doxytag: member="array_ops.sql_in::array_agg" ref="af9f60293134ba4ce05b1f97f6faba822" args="(anyelement)" --> |
| 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><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> |
| </table> |
| <hr/><a name="details" id="details"></a><h2>Detailed Description</h2> |
| <div class="textblock"><dl class="date"><dt><b>Date:</b></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><hr/><h2>Function Documentation</h2> |
| <a class="anchor" id="a91c8d3715142927b3967f05a4fbf1575"></a><!-- doxytag: member="array_ops.sql_in::array_add" ref="a91c8d3715142927b3967f05a4fbf1575" args="(anyarray x, anyarray y)" --> |
| <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><dt><b>Parameters:</b></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="return"><dt><b>Returns:</b></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><!-- doxytag: member="array_ops.sql_in::array_contains" ref="aedf6cb13eb4803bcc12dc4d95ea8ff4e" args="(anyarray x, anyarray y)" --> |
| <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><dt><b>Parameters:</b></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="return"><dt><b>Returns:</b></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><!-- doxytag: member="array_ops.sql_in::array_div" ref="a6cc05e7052495f8b64692faf40219576" args="(anyarray x, anyarray y)" --> |
| <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><dt><b>Parameters:</b></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="return"><dt><b>Returns:</b></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><!-- doxytag: member="array_ops.sql_in::array_dot" ref="acde10964ed23b7c8da515fb84cb8d5e0" args="(anyarray x, anyarray y)" --> |
| <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><dt><b>Parameters:</b></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="return"><dt><b>Returns:</b></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><!-- doxytag: member="array_ops.sql_in::array_fill" ref="a065a5323f3b742be47e39ad8b4c90fc2" args="(anyarray x, anyelement k)" --> |
| <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><dt><b>Parameters:</b></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="return"><dt><b>Returns:</b></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><!-- doxytag: member="array_ops.sql_in::array_max" ref="ae891429cc50705c530f3e5ca15541849" args="(anyarray x)" --> |
| <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><dt><b>Parameters:</b></dt><dd> |
| <table class="params"> |
| <tr><td class="paramname">x</td><td>Array x </td></tr> |
| </table> |
| </dd> |
| </dl> |
| <dl class="return"><dt><b>Returns:</b></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><!-- doxytag: member="array_ops.sql_in::array_mean" ref="a407598f9eb70637798b02fd731bfca2c" args="(anyarray x)" --> |
| <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><dt><b>Parameters:</b></dt><dd> |
| <table class="params"> |
| <tr><td class="paramname">x</td><td>Array x </td></tr> |
| </table> |
| </dd> |
| </dl> |
| <dl class="return"><dt><b>Returns:</b></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><!-- doxytag: member="array_ops.sql_in::array_min" ref="a6659bf9d9363eb179fab34f81f8ac59b" args="(anyarray x)" --> |
| <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><dt><b>Parameters:</b></dt><dd> |
| <table class="params"> |
| <tr><td class="paramname">x</td><td>Array x </td></tr> |
| </table> |
| </dd> |
| </dl> |
| <dl class="return"><dt><b>Returns:</b></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><!-- doxytag: member="array_ops.sql_in::array_mult" ref="a652d70c480d484c4a1a92ded384b0dd7" args="(anyarray x, anyarray y)" --> |
| <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><dt><b>Parameters:</b></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="return"><dt><b>Returns:</b></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><!-- doxytag: member="array_ops.sql_in::array_of_bigint" ref="a4b562ee8fb5b3f974fdc56093c0cc9dd" args="(int4 k)" --> |
| <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><dt><b>Parameters:</b></dt><dd> |
| <table class="params"> |
| <tr><td class="paramname">k</td><td>Array size. </td></tr> |
| </table> |
| </dd> |
| </dl> |
| <dl class="return"><dt><b>Returns:</b></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><!-- doxytag: member="array_ops.sql_in::array_of_float" ref="a2c42a29f01aeab521073bb329fa4d239" args="(int4 k)" --> |
| <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><dt><b>Parameters:</b></dt><dd> |
| <table class="params"> |
| <tr><td class="paramname">k</td><td>Array size </td></tr> |
| </table> |
| </dd> |
| </dl> |
| <dl class="return"><dt><b>Returns:</b></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><!-- doxytag: member="array_ops.sql_in::array_scalar_mult" ref="ae6881cc5c86941b6ffca35d7f3cd5c12" args="(anyarray x, anyelement k)" --> |
| <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><dt><b>Parameters:</b></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="return"><dt><b>Returns:</b></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><!-- doxytag: member="array_ops.sql_in::array_sqrt" ref="a66195b7521ba0491f7fcbb54b10f335d" args="(anyarray x)" --> |
| <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><dt><b>Parameters:</b></dt><dd> |
| <table class="params"> |
| <tr><td class="paramname">x</td><td>Array x </td></tr> |
| </table> |
| </dd> |
| </dl> |
| <dl class="return"><dt><b>Returns:</b></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><!-- doxytag: member="array_ops.sql_in::array_stddev" ref="a3b6c2d173a611e6d6b184d825c2b336d" args="(anyarray x)" --> |
| <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><dt><b>Parameters:</b></dt><dd> |
| <table class="params"> |
| <tr><td class="paramname">x</td><td>Array x </td></tr> |
| </table> |
| </dd> |
| </dl> |
| <dl class="return"><dt><b>Returns:</b></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><!-- doxytag: member="array_ops.sql_in::array_sub" ref="a2875a161a01c7dcdea9a4997b074eefc" args="(anyarray x, anyarray y)" --> |
| <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><dt><b>Parameters:</b></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="return"><dt><b>Returns:</b></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><!-- doxytag: member="array_ops.sql_in::array_sum" ref="a4c98f20e6a737358806f63318daea5ec" args="(anyarray x)" --> |
| <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><dt><b>Parameters:</b></dt><dd> |
| <table class="params"> |
| <tr><td class="paramname">x</td><td>Array x </td></tr> |
| </table> |
| </dd> |
| </dl> |
| <dl class="return"><dt><b>Returns:</b></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><!-- doxytag: member="array_ops.sql_in::array_sum_big" ref="a418de59800833aa95f9b7cbd6b12901c" args="(anyarray x)" --> |
| <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><dt><b>Parameters:</b></dt><dd> |
| <table class="params"> |
| <tr><td class="paramname">x</td><td>Array x </td></tr> |
| </table> |
| </dd> |
| </dl> |
| <dl class="return"><dt><b>Returns:</b></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><!-- doxytag: member="array_ops.sql_in::normalize" ref="adf90038b728d1904b03767cc79dd9561" args="(float8[] x)" --> |
| <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><dt><b>Parameters:</b></dt><dd> |
| <table class="params"> |
| <tr><td class="paramname">x</td><td>Array x. </td></tr> |
| </table> |
| </dd> |
| </dl> |
| <dl class="return"><dt><b>Returns:</b></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> |
| </div> |
| <div id="nav-path" class="navpath"> |
| <ul> |
| <li class="navelem"><a class="el" href="array__ops_8sql__in.html">array_ops.sql_in</a> </li> |
| <!-- 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></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> |
| |
| |
| <li class="footer">Generated on Tue Apr 2 2013 14:57:03 for MADlib by |
| <a href="http://www.doxygen.org/index.html"> |
| <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.7.5.1 </li> |
| </ul> |
| </div> |
| |
| |
| </body> |
| </html> |
