Function Syntax Help

Поиск
Список
Период
Сортировка
От Plugge, Joe R.
Тема Function Syntax Help
Дата
Msg-id BD69807DAE0CE44CA00A8338D0FDD083534BA92E@oma00cexmbx03.corp.westworlds.com
обсуждение исходный текст
Ответы Re: Function Syntax Help  (Brian Modra <brian@zwartberg.com>)
Список pgsql-sql
<div class="Section1"><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">I am trying
tocreate a function that will grind through a cdr table and populate another table.  I am trying to load the function
andam getting the following error:</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> </span><pclass="MsoPlainText">ERROR:  function result type
mustbe specified<p class="MsoPlainText"> <p class="MsoPlainText"> <p class="MsoPlainText">CREATE FUNCTION
gen_simultaneous_calls(mystarttimestamp, mystop timestamp) AS $$ DECLARE<p class="MsoPlainText">    mycount integer;<p
class="MsoPlainText">BEGIN<pclass="MsoPlainText">    WHILE mystart < mystop + INTERVAL '1 day' LOOP<p
class="MsoPlainText">   SELECT INTO mycount  count(*) FROM log_calls WHERE startdate < mystart and enddate >
mystop;<pclass="MsoPlainText">    INSERT INTO simultaneous_calls_rpt (startdate,call_count) VALUES (mystart,mycount);<p
class="MsoPlainText">   mystart := mystart + INTERVAL '1 minute';<p class="MsoPlainText">    mystop  := mystop +
INTERVAL'1 minute';<p class="MsoPlainText">    END LOOP;<p class="MsoPlainText">END;<p class="MsoPlainText">    $$
LANGUAGE'plpgsql' STABLE;<p class="MsoPlainText"> <p class="MsoPlainText"> <p class="MsoPlainText"> <p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Tahoma","sans-serif""> </span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> </span><pclass="MsoNormal"><img align="left" alt="image001"
height="66"hspace="12" src="cid:image002.jpg@01CA596B.59B9EC10" v:shapes="Picture_x0020_3" width="79" /><b><span
style="font-size:10.0pt;
font-family:"Verdana","sans-serif";color:#999999">Joe R. Plugge</span></b><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif""></span><pclass="MsoNormal"><b><span
style="font-size:8.0pt;font-family:"Verdana","sans-serif";
color:#999999">Database Administrator, West Interactive Corporation</span></b><p class="MsoNormal"><b><span
style="font-size:8.0pt;font-family:"Verdana","sans-serif";
color:#999999">11650 Miracle Hills Drive, Omaha NE 68154</span></b><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif""></span><pclass="MsoNormal"><b><span
style="font-size:8.0pt;font-family:"Verdana","sans-serif";
color:#999999">402-716-0349 | Cell 402-517-2710 | jrplugge@west.com</span></b><b><span
style="font-size:8.0pt;font-family:"Verdana","sans-serif";color:navy"></span></b><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif""></span><pclass="MsoNormal"><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif""> </span><p class="MsoNormal"><i><span
style="font-size:8.0pt;font-family:"TimesNew Roman","serif"; 
color:black">This electronic message transmission, including any attachments, contains information from West
Corporationwhich may be confidential or privileged. The information is intended to be for the use of the individual or
entitynamed above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of
thecontents of this information is prohibited. </span></i><p class="MsoNormal"><i><span
style="font-size:8.0pt;font-family:"TimesNew Roman","serif"; 
color:black"> </span></i><p class="MsoNormal"><i><span style="font-size:8.0pt;font-family:"Times New Roman","serif";
color:black">If you have received this electronic transmission in error, please notify the sender immediately by a
"replyto sender only" message and destroy all electronic and hard copies of the communication, including
attachments.</span></i></div>

В списке pgsql-sql по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: slow count(CASE) query
Следующее
От: Brian Modra
Дата:
Сообщение: Re: Function Syntax Help