Re: [SQL] Function Syntax Help

2009-10-30 Thread Tom Lane
"Plugge, Joe R." writes: > Thanks, I changed my code to this, it compiled, and it seems to be running > now: It looks like you are expecting assignment to the input parameters to do something useful ... it will not. Maybe you need some output parameters? regards, tom la

Re: [SQL] Function Syntax Help

2009-10-30 Thread Plugge, Joe R.
[email protected]>] On Behalf Of Brian Modra Sent: Friday, October 30, 2009 2:29 PM To: Plugge, Joe R. Cc: [email protected]<mailto:[email protected]> Subject: Re: [SQL] Function Syntax Help 2009/10/30 Plugge, Joe R. mailto:[email protected]>> I am trying to crea

Re: [SQL] Function Syntax Help

2009-10-30 Thread Brian Modra
dify the new variables... > > > > > > > *From:* [email protected] [mailto:[email protected]] *On Behalf > Of *Brian Modra > *Sent:* Friday, October 30, 2009 2:29 PM > *To:* Plugge, Joe R. > *Cc:* [email protected] > *Subject:* Re: [SQL] Function Syntax

Re: [SQL] Function Syntax Help

2009-10-30 Thread Plugge, Joe R.
il.com] On Behalf Of Brian Modra Sent: Friday, October 30, 2009 2:29 PM To: Plugge, Joe R. Cc: [email protected] Subject: Re: [SQL] Function Syntax Help 2009/10/30 Plugge, Joe R. mailto:[email protected]>> I am trying to create a function that will grind through a cdr table and p

Re: [SQL] Function Syntax Help

2009-10-30 Thread Brian Modra
2009/10/30 Plugge, Joe R. > I am trying to create a function that will grind through a cdr table and > populate another table. I am trying to load the function and am getting the > following error: > > > > ERROR: function result type must be specified > > > > > > CREATE FUNCTION gen_simultaneo

[SQL] Function Syntax Help

2009-10-30 Thread Plugge, Joe R.
I am trying to create a function that will grind through a cdr table and populate another table. I am trying to load the function and am getting the following error: ERROR: function result type must be specified CREATE FUNCTION gen_simultaneous_calls(mystart timestamp, mystop timestamp)