Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 672036329E1 for ; Fri, 11 Jun 2010 11:17:57 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 67143-02 for ; Fri, 11 Jun 2010 14:17:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.jfcomputer.com (unknown [76.14.161.106]) by mail.postgresql.org (Postfix) with ESMTP id 34CB76323FE for ; Fri, 11 Jun 2010 11:17:50 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mail.jfcomputer.com (Postfix) with ESMTP id 708587DDC9 for ; Fri, 11 Jun 2010 07:17:47 -0700 (PDT) X-Virus-Scanned: amavisd-new at jfcomputer.com Received: from mail.jfcomputer.com ([127.0.0.1]) by localhost (server1.jfcomputer.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id SoeQ1RQn6J97 for ; Fri, 11 Jun 2010 07:17:45 -0700 (PDT) Received: from [192.168.1.219] (unknown [192.168.1.219]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: johnf@mail.jfcomputer.com) by mail.jfcomputer.com (Postfix) with ESMTPSA id 3D5D17DDCC for ; Fri, 11 Jun 2010 07:17:45 -0700 (PDT) From: John To: pgsql-sql@postgresql.org Subject: is there a tutorial on window functions? Date: Fri, 11 Jun 2010 07:17:44 -0700 User-Agent: KMail/1.9.9 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <201006110717.44963.johnf@jfcomputer.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.593 tagged_above=-5 required=5 tests=BAYES_50=0.8, RDNS_NONE=0.793 X-Spam-Level: * X-Archive-Number: 201006/44 X-Sequence-Number: 34235 Hi, I'd like to learn the use of window functions and did not find a tutorial using google ("postgres window function tutorial"). I'm hoping someone has a link. Johnf