X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 7C1809FB263
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 28 Jul 2006 15:01:55 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 69675-10 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 28 Jul 2006 15:01:37 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from nf-out-0910.google.com (nf-out-0910.google.com
 [64.233.182.188])
	by postgresql.org (Postfix) with ESMTP id 777E79FA4E3
	for <pgsql-sql@postgresql.org>; Fri, 28 Jul 2006 15:01:33 -0300 (ADT)
Received: by nf-out-0910.google.com with SMTP id p77so261081nfc
	for <pgsql-sql@postgresql.org>; Fri, 28 Jul 2006 11:01:30 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth;
	b=sZsHdzH522EwejA1XWQJW1jUq5hdzsT+MMWA4NkZZleFvKinPLv7zR+SRvU2GKulOhQz5jH0jXQjB77PpptfF+L4vufCmX20UQuYMUnmx1m40Kim/k2ah+33mQPFEOcVYqjVFldMTrWZtXAenHBqzbO4gt834Cz/TBB06Pr3644=
Received: by 10.48.1.4 with SMTP id 4mr1049384nfa;
	Fri, 28 Jul 2006 11:01:30 -0700 (PDT)
Received: by 10.48.243.8 with HTTP; Fri, 28 Jul 2006 11:01:30 -0700 (PDT)
Message-ID: <fdb4b04c0607281101s5b48dce0v69cc381c23f04343@mail.gmail.com>
Date: Fri, 28 Jul 2006 13:01:30 -0500
From: "Chris Lukenbill" <chris@blendinteractive.com>
To: "Michael Fuhr" <mike@fuhr.org>
Subject: Re: return setof records
Cc: pgsql-sql@postgresql.org
In-Reply-To: <20060728141348.GA95234@winnie.fuhr.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_254242_31586476.1154109690712"
References: <1154032891.v2.fusewebmail-168507@ffuse18>
	<20060728141348.GA95234@winnie.fuhr.org>
X-Google-Sender-Auth: 4114e341ec150bd4
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=HTML_MESSAGE,
	SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200607/359
X-Sequence-Number: 25933

------=_Part_254242_31586476.1154109690712
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I think that actually solved the problem. The fact that I was sending back a
bigint.  One of those things that's hard to spot when I don't know if I was
on the right track to begin with.  Thank you everyone for your help.

Chris

On 7/28/06, Michael Fuhr <mike@fuhr.org> wrote:
>
> On Thu, Jul 27, 2006 at 03:41:31PM -0500, Chris Lukenbill wrote:
> > Everywhere I've looked the agreement was that making a call to the
> > function had to be done as follows:
> >
> > SELECT * FROM sp_frontalerts_summary(1,'2006-07-27 18:08:09','2006-07-27
> > 19:58:15' ) as (numitems int, region int);
>
> That's one way.  Another way would be for the function to use OUT
> parameters (if you're running 8.1) or to return a custom type so
> you could omit the column definition list.  Then the query would be:
>
> SELECT *
> FROM sp_frontalerts_summary(1, '2006-07-27 18:08:09', '2006-07-27
> 19:58:15');
>
> > So there isn't a question on that.  My question is, how do I return a
> > "setof record" back to the application.
>
> The function and how you're calling it look correct except that
> count() returns bigint, not int.  You didn't mention what error
> you're getting but I'd guess it's "wrong record type supplied in
> RETURN NEXT".  Try using "numitems bigint" instead of "numitems int".
>
> --
> Michael Fuhr
>
>

------=_Part_254242_31586476.1154109690712
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I think that actually solved the problem. The fact that I was sending back a bigint.&nbsp; One of those things that's hard to spot when I don't know if I was on the right track to begin with.&nbsp; Thank you everyone for your help.<br>
<br>Chris<br><br><div><span class="gmail_quote">On 7/28/06, <b class="gmail_sendername">Michael Fuhr</b> &lt;<a href="mailto:mike@fuhr.org">mike@fuhr.org</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Thu, Jul 27, 2006 at 03:41:31PM -0500, Chris Lukenbill wrote:<br>&gt; Everywhere I've looked the agreement was that making a call to the<br>&gt; function had to be done as follows:<br>&gt;<br>&gt; SELECT * FROM sp_frontalerts_summary(1,'2006-07-27 18:08:09','2006-07-27
<br>&gt; 19:58:15' ) as (numitems int, region int);<br><br>That's one way.&nbsp;&nbsp;Another way would be for the function to use OUT<br>parameters (if you're running 8.1) or to return a custom type so<br>you could omit the column definition list.&nbsp;&nbsp;Then the query would be:
<br><br>SELECT *<br>FROM sp_frontalerts_summary(1, '2006-07-27 18:08:09', '2006-07-27 19:58:15');<br><br>&gt; So there isn't a question on that.&nbsp;&nbsp;My question is, how do I return a<br>&gt; &quot;setof record&quot; back to the application.
<br><br>The function and how you're calling it look correct except that<br>count() returns bigint, not int.&nbsp;&nbsp;You didn't mention what error<br>you're getting but I'd guess it's &quot;wrong record type supplied in<br>RETURN NEXT&quot;.&nbsp;&nbsp;Try using &quot;numitems bigint&quot; instead of &quot;numitems int&quot;.
<br><br>--<br>Michael Fuhr<br><br></blockquote></div><br>

------=_Part_254242_31586476.1154109690712--