<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:m="http://schemas.microsoft.com/office/2004/12/omml" 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 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></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="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal">CREATE or REPLACE FUNCTION DEMO(latitude double precision, longitude double precision)<o:p></o:p></p>
<p class="MsoNormal">RETURNS TABLE (Tmsgcount bigint,utc_time double precision) as $$<o:p></o:p></p>
<p class="MsoNormal">BEGIN<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">RETURN QUERY select <o:p></o:p></p>
<p class="MsoNormal"> count(msgno)::bigint as Tmsgcount<o:p></o:p></p>
<p class="MsoNormal">, floor(utc_time) :: double precision as utc_time<o:p></o:p></p>
<p class="MsoNormal">from transmitter_primary<o:p></o:p></p>
<p class="MsoNormal">where st_dwithin(st_geogfromtext('SRID=4326;POINT(' || longitude || ' ' || latitude || ')'),geog,10)='t'
<o:p></o:p></p>
<p class="MsoNormal">group by floor(utc_time) <o:p></o:p></p>
<p class="MsoNormal">order by floor(utc_time);<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">END;<o:p></o:p></p>
<p class="MsoNormal">$$ LANGUAGE plpgsql;<o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Cambria","serif";color:black">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Cambria","serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Cambria","serif";color:black">Kedar Tambade </span><span style="font-family:"Calibri","sans-serif";color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:black">This electronic mail message and any attached files contain information intended for the exclusive use of the individual or entity to whom it is addressed and
may contain information that is propriety, privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any viewing, copying, disclosure or distribution of this information
may be subject to legal restriction or sanction. Please notify the sender, by electronic mail or telephone, of any unintended recipients and delete the original message without making any copies.</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<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""> postgis-users-bounces@lists.osgeo.org [mailto:postgis-users-bounces@lists.osgeo.org]
<b>On Behalf Of </b>tasha dewasi<br>
<b>Sent:</b> Monday, February 04, 2013 7:57 AM<br>
<b>To:</b> PostGIS Users Discussion<br>
<b>Subject:</b> [postgis-users] Postgresql create function<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">hello,<o:p></o:p></p>
<div>
<p class="MsoNormal">I am trying to create a function, but instead of returning me all the rows from a table, it is just returning me count of rows<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">I don't understand whats wrong.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Please guide me<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">here's my code:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">CREATE or REPLACE FUNCTION DEMO(latitude double precision, longitude double precision)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">RETURNS TABLE (Tmsgcount bigint,utc_time double precision) as $$<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">BEGIN<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">create temporary table Transmitter as select count(msgno) TransCount,floor(utc_time) Trans_time from transmitter_primary where <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">st_dwithin(st_geogfromtext('SRID=4326;POINT(' || longitude || ' ' || latitude || ')'),geog,10)='t' group by floor(utc_time) order by floor(utc_time);<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">RETURN QUERY select * from Transmitter;<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">END;<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">$$ LANGUAGE plpgsql;<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">and it returns me just this value<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">13034;<o:p></o:p></p>
</div>
</div>
</body>
</html>