pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedis there a tutorial on window functions?
5+ messages / 4 participants
[nested] [flat]
* is there a tutorial on window functions?
@ 2010-06-11 14:17 John <johnf@jfcomputer.com>
2010-06-11 14:37 ` Re: is there a tutorial on window functions? Andreas Kretschmer <akretschmer@spamfence.net>
2010-06-11 14:39 ` Re: is there a tutorial on window functions? Thomas Kellerer <spam_eater@gmx.net>
0 siblings, 2 replies; 5+ messages in thread
From: John @ 2010-06-11 14:17 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: is there a tutorial on window functions?
2010-06-11 14:17 is there a tutorial on window functions? John <johnf@jfcomputer.com>
@ 2010-06-11 14:37 ` Andreas Kretschmer <akretschmer@spamfence.net>
2010-06-11 14:54 ` Re: is there a tutorial on window functions? John <johnf@jfcomputer.com>
1 sibling, 1 reply; 5+ messages in thread
From: Andreas Kretschmer @ 2010-06-11 14:37 UTC (permalink / raw)
To: pgsql-sql
John <johnf@jfcomputer.com> wrote:
> 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.
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°, E 13.56889°
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: is there a tutorial on window functions?
2010-06-11 14:17 is there a tutorial on window functions? John <johnf@jfcomputer.com>
2010-06-11 14:37 ` Re: is there a tutorial on window functions? Andreas Kretschmer <akretschmer@spamfence.net>
@ 2010-06-11 14:54 ` John <johnf@jfcomputer.com>
0 siblings, 0 replies; 5+ messages in thread
From: John @ 2010-06-11 14:54 UTC (permalink / raw)
To: pgsql-sql
On Friday 11 June 2010 07:37:29 am Andreas Kretschmer wrote:
> John <johnf@jfcomputer.com> wrote:
> > 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.
>
> 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°, E 13.56889°
Thanks all
Johnf
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: is there a tutorial on window functions?
2010-06-11 14:17 is there a tutorial on window functions? John <johnf@jfcomputer.com>
@ 2010-06-11 14:39 ` Thomas Kellerer <spam_eater@gmx.net>
2010-06-11 14:49 ` Re: is there a tutorial on window functions? Kenneth Marshall <ktm@rice.edu>
1 sibling, 1 reply; 5+ messages in thread
From: Thomas Kellerer @ 2010-06-11 14:39 UTC (permalink / raw)
To: pgsql-sql
John, 11.06.2010 16:17:
> 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.
There is one in the manual:
http://www.postgresql.org/docs/current/static/tutorial-window.html
Thomas
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: is there a tutorial on window functions?
2010-06-11 14:17 is there a tutorial on window functions? John <johnf@jfcomputer.com>
2010-06-11 14:39 ` Re: is there a tutorial on window functions? Thomas Kellerer <spam_eater@gmx.net>
@ 2010-06-11 14:49 ` Kenneth Marshall <ktm@rice.edu>
0 siblings, 0 replies; 5+ messages in thread
From: Kenneth Marshall @ 2010-06-11 14:49 UTC (permalink / raw)
To: Thomas Kellerer <spam_eater@gmx.net>; +Cc: pgsql-sql
On Fri, Jun 11, 2010 at 04:39:37PM +0200, Thomas Kellerer wrote:
> John, 11.06.2010 16:17:
>> 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.
>
> There is one in the manual:
>
> http://www.postgresql.org/docs/current/static/tutorial-window.html
>
> Thomas
>
You can also search online for window function examples for
various other SQL databases and they pretty much work too.
Ken
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2010-06-11 14:54 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-06-11 14:17 is there a tutorial on window functions? John <johnf@jfcomputer.com>
2010-06-11 14:37 ` Andreas Kretschmer <akretschmer@spamfence.net>
2010-06-11 14:54 ` John <johnf@jfcomputer.com>
2010-06-11 14:39 ` Thomas Kellerer <spam_eater@gmx.net>
2010-06-11 14:49 ` Kenneth Marshall <ktm@rice.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox