Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 298C3632566 for ; Fri, 11 Jun 2010 11:54:28 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 17087-02 for ; Fri, 11 Jun 2010 14:54:19 +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 DFC1C63234F for ; Fri, 11 Jun 2010 11:54:20 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mail.jfcomputer.com (Postfix) with ESMTP id 058A17DDCC for ; Fri, 11 Jun 2010 07:54:19 -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 Yh7bI24dnEX5 for ; Fri, 11 Jun 2010 07:54:16 -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 AE6AA7DDA6 for ; Fri, 11 Jun 2010 07:54:16 -0700 (PDT) From: John To: pgsql-sql@postgresql.org Subject: Re: is there a tutorial on window functions? Date: Fri, 11 Jun 2010 07:54:16 -0700 User-Agent: KMail/1.9.9 References: <201006110717.44963.johnf@jfcomputer.com> <20100611143729.GA10503@tux> In-Reply-To: <20100611143729.GA10503@tux> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <201006110754.16514.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/48 X-Sequence-Number: 34239 On Friday 11 June 2010 07:37:29 am Andreas Kretschmer wrote: > John wrote: > > Hi, > > I'd like to learn the use of window functions and did not find a tutori= al > > using google ("postgres window function tutorial"). I'm hoping someone > > has a link. > > My link-collection: http://delicious.com/akretschmer/windowing and > http://delicious.com/akretschmer/cte > > > Andreas > -- > Really, I'm not out to destroy Microsoft. That will just be a completely > unintentional side effect. (Linus Torvalds) > "If I was god, I would recompile penguin with --enable-fly." (unknown) > Kaufbach, Saxony, Germany, Europe. N 51.05082=B0, E 13.56889= =B0 Thanks all Johnf