Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id DB6029FA2B0 for ; Tue, 25 Sep 2007 01:46:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 61063-05 for ; Tue, 25 Sep 2007 01:46:30 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.230]) by postgresql.org (Postfix) with ESMTP id B0E3A9F9FE6 for ; Tue, 25 Sep 2007 01:46:36 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id r21so1275450wxc for ; Mon, 24 Sep 2007 21:46:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=cO79tTWsX01Kr+yw7vuXkYQDxA4IW6cvyfoVNF8Pnbk=; b=R5mGyaI9LIyC2RR650qp438f4Q2yu/JBKKr1iweyne/9eFoIGiqVZal5AsS+V/+gQsHqa0G5aVdFDzTsuwh+x430f+YYuPu7diskxFpdojGj8O93SNxbUqEw97ensSJjAn16uBjb2CHxfPafc1gjeXxSC5kgqNGkGyR+hZQF04s= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ESqBRHVcf9T2Oaxq1Ou0uC5xSSWoaFd6l8o4VN4dapme2vAN2b9shCuaqaXz9CqhbCF5ObFC9jJcmVIp6ejgU0shHRCZsqtbxAOxaSRAM2J5z278lw9jzV30n5hRwBr2Onmd7mo9Bgn7UKBAjykhbeA6NSyNpTwvcpmKyZUFXOw= Received: by 10.90.78.9 with SMTP id a9mr6226459agb.1190695595845; Mon, 24 Sep 2007 21:46:35 -0700 (PDT) Received: by 10.90.30.9 with HTTP; Mon, 24 Sep 2007 21:46:35 -0700 (PDT) Message-ID: <162867790709242146m70791358gfe2a9045b6512ece@mail.gmail.com> Date: Tue, 25 Sep 2007 06:46:35 +0200 From: "Pavel Stehule" To: "Rhys Stewart" Subject: Re: set returning functions. Cc: "Scott Marlowe" , pgsql-general@postgresql.org In-Reply-To: <189966030709241618p1f104e2ep55a9f8f5725ef90@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <189966030709211129t7147b726w25f415489f25b874@mail.gmail.com> <162867790709241509k16bbe691v94c9ef2748fbbba@mail.gmail.com> <189966030709241618p1f104e2ep55a9f8f5725ef90@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/1141 X-Sequence-Number: 121063 2007/9/25, Rhys Stewart : > yes indeed. thats exactly it scott!!! > > On 9/24/07, Scott Marlowe wrote: > > On 9/24/07, Pavel Stehule wrote: > > > Hello Rhys > > > > > > its not mystery > > > > Yeah, but I think he wanted to be able to make his own function he > > could call like: > > > > select myfunc(10); > > Then you have to use sql language create or replace function mysrf(int) returns setof integer as $$ select i from generate_series(1, $1) g(i); $$ language sql; Regards Pavel Stehule