<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:D="DAV:" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<title>Re: [fdo-internals] New RFC posted</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Times New Roman","serif";
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'>Hi Jason<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'>For functions like
MOD and REMAINDER, the intent is to use the same data type for the return value
as used for the first parameter. In some cases, this is not possible and hence
the return type is different. For example, look at the signatures for the
function MOD where the first parameter is an int16 and the second parameter
either a decimal, double, int16, int32, int64 or single data type. In this
example, the return value differs based on the provided values:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'>Signature Return
Value Data Type<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'>--------------------------------------------------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'>Mod (FdoDataType_Int16,
FdoDataType_Decimal) FdoDataType_Double<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'>Mod (FdoDataType_Int16,
FdoDataType_Double) FdoDataType_Double<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'>Mod (FdoDataType_Int16,
FdoDataType_Int16) FdoDataType_Int16<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'>Mod (FdoDataType_Int16,
FdoDataType_Int32) FdoDataType_Int16<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'>Mod (FdoDataType_Int16,
FdoDataType_Int64) FdoDataType_Int16<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'>Mod (FdoDataType_Int16,
FdoDataType_Single) FdoDataType_Single<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'>Does that answer
your question?<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'>Thanks<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'> Thomas<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-internals-bounces@lists.osgeo.org
[mailto:fdo-internals-bounces@lists.osgeo.org] <b>On Behalf Of </b>Jason Birch<br>
<b>Sent:</b> Tuesday, August 21, 2007 7:21 PM<br>
<b>To:</b> FDO Internals Mail List<br>
<b>Subject:</b> RE: [fdo-internals] New RFC posted<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'>Me too</span><o:p></o:p></p>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'>J</span><o:p></o:p></p>
</div>
<p class=MsoNormal><span style='font-size:10.0pt;color:blue'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-internals-bounces@lists.osgeo.org
[mailto:fdo-internals-bounces@lists.osgeo.org] <b>On Behalf Of </b>Jason Birch<br>
<b>Sent:</b> Tuesday, August 21, 2007 5:54 PM<br>
<b>To:</b> FDO Internals Mail List<br>
<b>Subject:</b> RE: [fdo-internals] New RFC posted<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'>- Would it be possible to add an integer DIV function as
well? Or is this just assumed when dividing integer values? Showing
some ignorance of FDO operations here...</span><o:p></o:p></p>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;color:#943634'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#943634'>[tok] I
don’t think we need this function. If you want the result of a division
of two integers to be an integer value, you could use the FLOOR or CEIL
function to achieve this.<o:p></o:p></span></p>
<p class=MsoNormal> <span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:green'>[jcb] OK. I guess this question stemmed from the
result type on the MOD/REMAINDER functions being diff_rv, assuming that the return
type would be based on the input parameters. Could you maybe clarify
under what cases various types are returned from these functions?</span><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue'><o:p></o:p></span></p>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'>Am I getting annoying yet? :)</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;color:#943634'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#943634'>[tok] No.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:green'>[jcb] Guess I'll have to try harder then...</span><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue'><o:p></o:p></span></p>
<p class=MsoNormal> <o:p></o:p></p>
</div>
</div>
</body>
</html>