Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 4E9839F949A for ; Fri, 21 Sep 2007 15:29:20 -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 21529-05 for ; Fri, 21 Sep 2007 15:29:09 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.176]) by postgresql.org (Postfix) with ESMTP id E3C7D9F9793 for ; Fri, 21 Sep 2007 15:29:08 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id u77so1916038pyb for ; Fri, 21 Sep 2007 11:29:08 -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:mime-version:content-type:content-transfer-encoding:content-disposition; bh=JhpTrJR4YEXSN3N5X1ynIKHZVbvjfIr3zro9zp7u5C8=; b=Wk8w2uvP31F6vvWq6T2cEPsQpLal2kUZWTsw8nAQxNEDZYVw7SQqo1wGeZXS3WaxyLAE3Bf00VNG9NEGXIJwPJDQrSqsyC7q7x4wKudEtgHGBCcTrnStS4N/U4a7DeJPF3EQ2vhLHxDEwUVNuZGhvW7qkQqtTgzkbXzQgVJmnOw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=r1SGU7ur+xUP0UoxBaOUi33+JAiXJeZDp8WVp9Ti28wENx3v0xs/vNpqI5xyc3ixkP0np+6J3IGPkE1OU5TrJPBxQ0X5XpaEFcM8rOuAJ2hTKzopL3v5Hamo4yoYXwHCCjzfabRYagEeGeTKIaaxZjQhuz0JkvVIvPgNkJKu9wE= Received: by 10.65.116.10 with SMTP id t10mr7344549qbm.1190399347636; Fri, 21 Sep 2007 11:29:07 -0700 (PDT) Received: by 10.64.153.11 with HTTP; Fri, 21 Sep 2007 11:29:07 -0700 (PDT) Message-ID: <189966030709211129t7147b726w25f415489f25b874@mail.gmail.com> Date: Fri, 21 Sep 2007 13:29:07 -0500 From: "Rhys Stewart" To: pgsql-general@postgresql.org Subject: set returning functions. MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/1120 X-Sequence-Number: 121042 Hi all, How can one make a set-returning function behave like generate_series(). If I cobble up an srf with plpgsql i have to do select * from mysrf(). But i can do select generate_series(1,10) or select this, that,the other,generate_series(1,5) from sometable. Essentially I would like to be able to have my srf behave like that. Rhys Live Long & Prosper | Peace & Love