Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 17D669F9BC1 for ; Tue, 25 Sep 2007 11:12:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 67443-05 for ; Tue, 25 Sep 2007 11:12:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175]) by postgresql.org (Postfix) with ESMTP id C8BC69F9278 for ; Tue, 25 Sep 2007 11:12:38 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so1030273ugf for ; Tue, 25 Sep 2007 07:12: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=7XNFqi7gyfU/eFywySqYd75pCFXcGzxM0wEG5Re3ciI=; b=nFovNiMLiNiwP8Jljuwh4GbGJxxmnSdSozSuGZQJ09kOouqIpopVbD1BgTilr/W4+aW2YA0kBxdrf+G9dJTBq2QAXia/I/gGvZmE1Ypa1rU+ikgz5j0R66cyw6IP8xnpGmfszSQVsDBxdp48twtPgwJkjz7qWBctxS4LP69wFBg= 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=EOEdCZ4cYfx2U8TCuf2ANSsRYF+LxIUcHyU7lyMUF2H/adP4iH1vdsYOu+oHdc6jZutRImhfyX6413nwKV7+YEtPGsh+EY2/C16rfW2g5IfPtBAwVGIjZvjZgPKoGR0imEYd3vjFLE2KdU/HZPZOUjm+/98CZO/EVzL6hBq6Thc= Received: by 10.66.224.3 with SMTP id w3mr889355ugg.1190729556428; Tue, 25 Sep 2007 07:12:36 -0700 (PDT) Received: by 10.66.220.7 with HTTP; Tue, 25 Sep 2007 07:12:36 -0700 (PDT) Message-ID: Date: Tue, 25 Sep 2007 09:12:36 -0500 From: "Scott Marlowe" To: "Pavel Stehule" Subject: Re: set returning functions. Cc: "Rhys Stewart" , pgsql-general@postgresql.org In-Reply-To: <162867790709242146m70791358gfe2a9045b6512ece@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <189966030709211129t7147b726w25f415489f25b874@mail.gmail.com> <162867790709241509k16bbe691v94c9ef2748fbbba@mail.gmail.com> <189966030709241618p1f104e2ep55a9f8f5725ef90@mail.gmail.com> <162867790709242146m70791358gfe2a9045b6512ece@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/1163 X-Sequence-Number: 121085 On 9/24/07, Pavel Stehule wrote: > 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; Do you HAVE to use sql plsql to get this to work? I thought that all pl languages worked like this with pgsql.