<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head profile="http://internetalchemy.org/2003/02/profile">
<link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" />
<link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" />
<meta name="dc.title" content="Function: equ - Virtuoso Functions Guide" />
<meta name="dc.subject" content="Function: equ - Virtuoso Functions Guide" />
<meta name="dc.creator" content="OpenLink Software Documentation Team ; " />
<meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" />
<link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" />
<link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" />
<link rel="parent" href="functions.html" title="Chapter Contents" />
<link rel="prev" href="appendixa.html" title="Appendix" />
<link rel="next" href="functions.html#.html" title="" />
<link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="doc.css" />
<link rel="stylesheet" type="text/css" href="/doc/translation.css" />
<title>Function: equ - Virtuoso Functions Guide</title>
<meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
<meta name="author" content="OpenLink Software Documentation Team ; " />
<meta name="copyright" content="OpenLink Software, 1999 - 2009" />
<meta name="keywords" content="" />
<meta name="GENERATOR" content="OpenLink XSLT Team" />
</head>
<body>
<div id="header">
<a name="fn_equ" />
<img src="../images/misc/logo.jpg" alt="" />
<h1>22. Virtuoso Functions Guide - equ</h1>
</div>
<div id="navbartop">
<div>
<a class="link" href="functions.html">Chapter Contents</a> | <a class="link" href="fn_either.html" title="either">Prev</a> | <a class="link" href="fn_exp.html" title="exp">Next</a>
</div>
</div>
<div id="currenttoc">
<form method="post" action="/doc/adv_search.vspx">
<div class="search">Keyword Search: <br />
<input type="text" name="q" /> <input type="submit" name="go" value="Go" />
</div>
</form>
<div>
<a href="http://www.openlinksw.com/">www.openlinksw.com</a>
</div>
<div>
<a href="http://docs.openlinksw.com/">docs.openlinksw.com</a>
</div>
<br />
<div>
<a href="index.html">Book Home</a>
</div>
<br />
<div>
<a href="contents.html">Contents</a>
</div>
<div>
<a href="preface.html">Preface</a>
</div>
<br />
<div>
<a class="selected" href="functions.html">Virtuoso Functions Guide</a>
</div>
<br />
<div>
<a href="functions.html#admin">Administration</a>
</div>
<div>
<a href="functions.html#aggr">Aggregate Functions</a>
</div>
<div>
<a href="functions.html#array">Array Manipulation</a>
</div>
<div>
<a href="functions.html#bpel">BPEL APIs</a>
</div>
<div>
<a href="functions.html#backup">Backup</a>
</div>
<div>
<a href="functions.html#compression">Compression</a>
</div>
<div>
<a href="functions.html#cursors">Cursor</a>
</div>
<div>
<a href="functions.html#time">Date & Time Manipulation</a>
</div>
<div>
<a href="functions.html#debug">Debug</a>
</div>
<div>
<a href="functions.html#dict">Dictionary Manipulation</a>
</div>
<div>
<a href="functions.html#encoding">Encoding & Decoding</a>
</div>
<div>
<a href="functions.html#file">File Manipulation</a>
</div>
<div>
<a href="functions.html#ft">Free Text</a>
</div>
<div>
<a href="functions.html#hash">Hashing / Cryptographic</a>
</div>
<div>
<a href="functions.html#ldap">LDAP</a>
</div>
<div>
<a href="functions.html#localization">Locale</a>
</div>
<div>
<a href="functions.html#mail">Mail</a>
</div>
<div>
<a href="functions.html#misc">Miscellaneous</a>
</div>
<div>
<a class="selected" href="functions.html#number">Number</a>
</div>
<div class="selected">
<div>
<a href="fn_nm_max.html">__max</a>
</div>
<div>
<a href="fn_nm_max_notnull.html">__max_notnull</a>
</div>
<div>
<a href="fn_nm_min.html">__min</a>
</div>
<div>
<a href="fn_nm_min_notnull.html">__min_notnull</a>
</div>
<div>
<a href="fn_abs.html">abs</a>
</div>
<div>
<a href="fn_atof.html">atof</a>
</div>
<div>
<a href="fn_atoi.html">atoi</a>
</div>
<div>
<a href="fn_bit_and.html">bit_and</a>
</div>
<div>
<a href="fn_bit_not.html">bit_not</a>
</div>
<div>
<a href="fn_bit_or.html">bit_or</a>
</div>
<div>
<a href="fn_bit_shift.html">bit_shift</a>
</div>
<div>
<a href="fn_bit_xor.html">bit_xor</a>
</div>
<div>
<a href="fn_ceiling.html">ceiling</a>
</div>
<div>
<a href="fn_either.html">either</a>
</div>
<div>
<a class="selected" href="fn_equ.html">equ</a>
</div>
<div>
<a href="fn_exp.html">exp</a>
</div>
<div>
<a href="fn_floor.html">floor</a>
</div>
<div>
<a href="fn_isdouble.html">isdouble</a>
</div>
<div>
<a href="fn_isfinitenumeric.html">isfinitenumeric</a>
</div>
<div>
<a href="fn_isfloat.html">isfloat</a>
</div>
<div>
<a href="fn_isinteger.html">isinteger</a>
</div>
<div>
<a href="fn_isnumeric.html">isnumeric</a>
</div>
<div>
<a href="fn_iszero.html">iszero</a>
</div>
<div>
<a href="fn_log.html">log</a>
</div>
<div>
<a href="fn_log10.html">log10</a>
</div>
<div>
<a href="fn_lower.html">lower</a>
</div>
<div>
<a href="fn_mod.html">mod</a>
</div>
<div>
<a href="fn_power.html">power</a>
</div>
<div>
<a href="fn_randomize.html">randomize</a>
</div>
<div>
<a href="fn_rnd.html">rnd</a>
</div>
<div>
<a href="fn_sign.html">sign</a>
</div>
<div>
<a href="fn_sqrt.html">sqrt</a>
</div>
<div>
<a href="fn_acos.html">trigonometric</a>
</div>
</div>
<div>
<a href="functions.html#phrz">Phrases</a>
</div>
<div>
<a href="functions.html#rdf">RDF data</a>
</div>
<div>
<a href="functions.html#rmt">Remote SQL Data Source</a>
</div>
<div>
<a href="functions.html#repl">Replication</a>
</div>
<div>
<a href="functions.html#soap">SOAP</a>
</div>
<div>
<a href="functions.html#sql">SQL</a>
</div>
<div>
<a href="functions.html#string">String</a>
</div>
<div>
<a href="functions.html#txn">Transaction</a>
</div>
<div>
<a href="functions.html#type">Type Mapping</a>
</div>
<div>
<a href="functions.html#uddi">UDDI</a>
</div>
<div>
<a href="functions.html#udt">User Defined Types & The CLR</a>
</div>
<div>
<a href="functions.html#vad">VAD</a>
</div>
<div>
<a href="functions.html#jvmpl">Virtuoso Java PL API</a>
</div>
<div>
<a href="functions.html#bif">Virtuoso Server Extension Interface (VSEI)</a>
</div>
<div>
<a href="functions.html#ws">Web & Internet</a>
</div>
<div>
<a href="functions.html#xml">XML</a>
</div>
<div>
<a href="functions.html#XPATH">XPATH & XQUERY</a>
</div>
<br />
<div>
<a href="functionidx.html">Functions Index</a>
</div>
<br />
</div>
<div id="text">
<h2>equ</h2>
<div class="refpurpose">comparison functions</div>
<div class="funcsynopsis">
<span class="funcdef">
<span class="function">equ</span>
</span>
(<span class="paramdef">
<span class="parameter">arg1</span> any</span>,
<span class="paramdef">
<span class="parameter">arg2</span> any</span>);
</div>
<div class="funcsynopsis">
<span class="funcdef"> <span class="function">gt</span> </span>
(<span class="paramdef">in <span class="parameter">arg1</span>any</span>,
<span class="paramdef">in <span class="parameter">arg2</span>any</span>);
</div>
<div class="funcsynopsis">
<span class="funcdef">
<span class="function">gte</span>
</span>
(<span class="paramdef">in<span class="parameter">arg1</span> any</span>,
<span class="paramdef">in<span class="parameter">arg2</span> any</span>);
</div>
<div class="funcsynopsis">
<span class="funcdef">
<span class="function">lt</span>
</span>
(<span class="paramdef">in <span class="parameter">arg1</span>any</span>,
<span class="paramdef">in <span class="parameter">arg2</span>any</span>);
</div>
<div class="funcsynopsis">
<span class="funcdef"> <span class="function">lte</span> </span>
(<span class="paramdef">in <span class="parameter">arg1</span>any</span>,
<span class="paramdef">in <span class="parameter">arg2</span>any</span>);
</div>
<div class="funcsynopsis">
<span class="funcdef">
<span class="function">neq</span>
</span>
(<span class="paramdef">in <span class="parameter">arg1</span>any</span>,
<span class="paramdef">in <span class="parameter">arg2</span>any</span>);
</div>
<div class="refsect1">
<div class="refsect1title">Description</div>
<p>These functions return 1 if their first argument is less than (lt),
less than or equivalent (lte), greater than (gt), greater than or
equivalent (gte), equivalent (equ), or not equivalent (neq) to the
second argument, respectively. If the arguments are not of the same type,
then an appropriate type coercion is done for them before
comparison. </p>
<p>These functions correspond to SQL query operators <, <=, >,
>=, = and <> and are needed because the SQL syntax does not
allow these operators to be used on the left side of
<span class="computeroutput">FROM</span> keyword in a <span class="computeroutput">SELECT</span>
statement.</p>
</div>
<div class="refsect1">
<div class="refsect1title">Parameters</div>
<div class="refsect2">
<span class="refsect2title">arg1, arg2 – </span>
<span class="computeroutput">integer</span>, <span class="computeroutput">float</span>, <span class="computeroutput">double
precision</span>, <span class="computeroutput">varchar</span> or <span class="computeroutput">NULL</span>.
</div>
</div>
<div class="refsect1">
<div class="refsect1title">Return Values</div>
<p>An <span class="computeroutput">integer</span> value of 1 or 0 is returned.</p>
</div>
<div class="refsect1">
<div class="refsect1title">Examples</div>
<a name="ex_equ" />
<div class="example">
<div class="exampletitle">Simple Example</div>
<div>
<pre class="screen">
lt('pata','pato') -> 1 (Yes, 'pata' is less than 'pato')
gt('barbar','bar') -> 1 (Yes, 'barbar' is greater than 'bar')
equ(17,17) -> 1 (seventeen is seventeen)
equ(17,17.0) -> 1 (regardless of number format)
equ(atof('17.0'),17.0)) -> 1 (as it seems be)
equ(atof('17.1'),17.1)) -> 0 (But not always! Beware!)
gte(1234,NULL) -> 0 (No, 1234 is not "greater"
than or equal to NULL)
lt(1234,NULL) -> 1 (Instead, it is "less" than NULL)
</pre>
</div>
</div>
</div>
<div class="refsect1">
<div class="refsect1title">See Also</div>
<p />
</div>
</div>
<div id="footer">
<div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div>
<div id="validation">
<a href="http://validator.w3.org/check/referer">
<img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" />
</a>
<a href="http://jigsaw.w3.org/css-validator/">
<img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" />
</a>
</div>
</div>
</body>
</html>
distrib
>
Fedora
>
14
>
x86_64
>
media
>
updates
>
by-pkgid
>
71d40963b505df4524269198e237b3e3
>
files
>
268
