<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="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)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<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-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'>Please see
comments inline.<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>
<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'>Thanks.</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'>Sounds like there is some ambiguity on what you would expect MOD or
REMAINDER to return. Can we just specify that for FDO the sign of the
return value must always be positive? Or that it must follow some other
rule? I'd hate to leave it up to the client to guess what will be
returned, based on the provider.</span><span style='font-size:10.0pt;
font-family:"Arial","sans-serif"'><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:#943634'>[tok] Actually,
the functions are well-defined and there is no guessing of the client what will
be returned. I’ll update the document to make this clearer.<o:p></o:p></span></p>
<p class=MsoNormal> <o:p></o:p></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;font-family:"Arial","sans-serif";
color:blue'>I'm not sure what I was talking about with code pages. Perhaps
I misread the intention of the Translate function, thinking that it would be
used to translate a string from one character set to another, rather than being
a string replacement function.</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'>Couple other minor picky questions:</span><o:p></o:p></p>
</div>
<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'>- For the function Sign, what would be the returned values? 0
or 1 for positive or negative? Something else?</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] Assuming
the call is Sign(x), the function returns -1 if x < 0, 0 if x == 0 and 1 if
x > 0. Again, I’ll update this in the document.<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:blue'>- Is the Instr position 0 or 1 based? What does it
return if the value doesn't exist?</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] The
function is 1-based. If a pattern does not exist, the function returns 0. I add
this to the document.<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: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>
<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> <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> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'>Jason</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=2 width="100%" align=center>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><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>Thomas
Knoell<br>
<b>Sent:</b> Tuesday, August 21, 2007 12:41<br>
<b>To:</b> FDO Internals Mail List<br>
<b>Subject:</b> RE: [fdo-internals] New RFC posted</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'>Hi Jason<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'>Sorry for the
late response on this as I did not get to do it during my vacation.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'>The issues with
the geometric functions like <i>area</i> and <i>length</i> are with coordinate
system/projection support. It is expected that this will result in some
discussion within the group. FDO includes coordinate system specification via
spatial context, but FDO itself does not expose any projection capabilities nor
does it specify use of coordinate system packages. Most providers do not have
coordinate system packages available internally. MapGuide for instance does all
of its projection work separately, outside of FDO. So, we should discuss what
happens if the data is lat/long for example.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'>Unlike the
geometric functions, the functions documented in RFC 8 are rather simple. The
idea was to keep those separated from the geometric functions to ensure nothing
gets overlooked and allow progress on implementing the basic functions while
discussion on geometric functions goes ahead.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'>As for the
functions <i>MOD</i> and <i>REMAINDER</i>, although the basically perform a
similar kind of operation, they are defined differently. The distinction is
with the sign of the return value: in case of the function MOD, it corresponds
to the sign of the divisor, in case of the function REMAINDER, it corresponds
to the sign of the dividend. Usually, in number theory, the remainder
(independent of the functions) is always a positive number. However, with
software products this might not be the case.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'>As for the math
operators with date functions, there was no intent to support such operators
other than on months. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'>As for the code
page question, I am not sure where you are heading here. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'>Thanks<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#1F497D'> 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>Thomas
Knoell<br>
<b>Sent:</b> Friday, August 03, 2007 6:39 PM<br>
<b>To:</b> fdo-internals@lists.osgeo.org<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 style='margin-bottom:12.0pt'><span style='font-size:10.0pt'>Hi Jason<br>
<br>
I will see what I can do. I am just leaving for my vacation and have to get
back to you on this next week (although being on vacation, I'll still try to
answer mails). I hope it can wait until then.<br>
<br>
Thanks<br>
<br>
Thomas<br>
<br>
--------------------------<br>
Sent from my BlackBerry Wireless Handheld (www.BlackBerry.net)<br>
<br>
<br>
----- Original Message -----<br>
From: fdo-internals-bounces@lists.osgeo.org
<fdo-internals-bounces@lists.osgeo.org><br>
To: FDO Internals Mail List <fdo-internals@lists.osgeo.org><br>
Sent: Fri Aug 03 18:06:32 2007<br>
Subject: RE: [fdo-internals] New RFC posted<br>
<br>
Could you maybe outline those issues? <br>
<br>
It would be helpful if we could all have an idea of what is coming up and see
how it fits together, rather than being fed RFCs / problems piecemeal.<br>
<br>
I was able to read the PDF version, btw, and it answers most of my
questions. I still don't know what the difference between Mod and
Remainder is though :)<br>
<br>
A couple functions raise questions for me<br>
<br>
- the date functions have month math operators, but none for other units?<br>
- is there a common way of specifying code pages that all providers should
understand? I don't know much about this area.<br>
<br>
Jason<br>
<br>
_____ <br>
<br>
From: fdo-internals-bounces@lists.osgeo.org [<a
href="mailto:fdo-internals-bounces@lists.osgeo.org">mailto:fdo-internals-bounces@lists.osgeo.org</a>]
On Behalf Of Thomas Knoell<br>
Sent: Friday, August 03, 2007 14:53<br>
To: fdo-internals@lists.osgeo.org<br>
Subject: Re: [fdo-internals] New RFC posted<br>
<br>
<br>
<br>
For the geometry functions, there are different issues to address which we
thought is better suited to be outlined separately.<br>
<br>
Thanks<br>
<br>
Thomas<br>
<br>
--------------------------<br>
Sent from my BlackBerry Wireless Handheld (www.BlackBerry.net)<br>
<br>
<br>
----- Original Message -----<br>
From: fdo-internals-bounces@lists.osgeo.org
<fdo-internals-bounces@lists.osgeo.org><br>
To: FDO Internals Mail List <fdo-internals@lists.osgeo.org><br>
Sent: Fri Aug 03 17:45:04 2007<br>
Subject: RE: [fdo-internals] New RFC posted<br>
<br>
Is there any specific reason for that ?<br>
<br>
<br>
<br>
Haris<br>
<br>
<br>
<br>
From: fdo-internals-bounces@lists.osgeo.org [<a
href="mailto:fdo-internals-bounces@lists.osgeo.org">mailto:fdo-internals-bounces@lists.osgeo.org</a>]
On Behalf Of Thomas Knoell<br>
Sent: Friday, August 03, 2007 11:40 PM<br>
To: fdo-internals@lists.osgeo.org<br>
Subject: Re: [fdo-internals] New RFC posted<br>
<br>
<br>
<br>
Spatial functions will be handled separately.<br>
<br>
--------------------------<br>
Sent from my BlackBerry Wireless Handheld (www.BlackBerry.net)<br>
<br>
<br>
----- Original Message -----<br>
From: fdo-internals-bounces@lists.osgeo.org <fdo-internals-bounces@lists.osgeo.org><br>
To: FDO Internals Mail List <fdo-internals@lists.osgeo.org><br>
Sent: Fri Aug 03 17:35:42 2007<br>
Subject: RE: [fdo-internals] New RFC posted<br>
<br>
I’ve noticed there is no any Spatial Functions. What is a reason for
that?<br>
<br>
<br>
<br>
Thank you,<br>
<br>
Haris<br>
<br>
<br>
<br>
From: fdo-internals-bounces@lists.osgeo.org [<a
href="mailto:fdo-internals-bounces@lists.osgeo.org">mailto:fdo-internals-bounces@lists.osgeo.org</a>]
On Behalf Of Thomas Knoell<br>
Sent: Friday, August 03, 2007 9:35 PM<br>
To: FDO Internals Mail List<br>
Subject: [fdo-internals] New RFC posted<br>
<br>
<br>
<br>
Hi,<br>
<br>
<br>
<br>
A new RFC (<a href="http://trac.osgeo.org/fdo/wiki/FDORfc8">http://trac.osgeo.org/fdo/wiki/FDORfc8</a>)
has been posted. The RFC addresses the enhancement of the FDO well known
(expression) function list to include additional, commonly used functions.<br>
<br>
<br>
<br>
Please review the RFC. Any comments/suggestions and questions are welcome. All
feedback is expected by the end-of-day August 10th 2007. If no changes are
required it is my intent to motion that a vote for the acceptance of the RFC be
made and subsequently voted on by the PSC.<br>
<br>
<br>
<br>
Thanks<br>
<br>
<br>
<br>
Thomas<br>
<br>
<br>
<br>
<br>
</span><o:p></o:p></p>
</div>
</body>
</html>