Tom Lane [EMAIL PROTECTED] writes:
Martijn van Oosterhout kleptog@svana.org writes:
The main thing I want to use them for is for cumulative output.
...
With window functions you define for each row a window which is from
the beginning of the table to that row and then sum the values, for
Alvaro Herrera wrote:
Karen Hill wrote:
It would be really great if PostgreSQL supported SQL:2003 Window
functions. I know that oracle and sql server have them already, so it
would make postgres competitive in that area. I know there is a
feature freeze for 8.2, is it doable for 8.3?
Karen Hill wrote:
Alvaro Herrera wrote:
Karen Hill wrote:
It would be really great if PostgreSQL supported SQL:2003 Window
functions. I know that oracle and sql server have them already, so it
would make postgres competitive in that area. I know there is a
feature freeze for
Bruce Momjian wrote:
Karen Hill wrote:
Alvaro Herrera wrote:
Karen Hill wrote:
It would be really great if PostgreSQL supported SQL:2003 Window
functions. I know that oracle and sql server have them already, so it
would make postgres competitive in that area. I know there
Alvaro Herrera wrote:
Bruce Momjian wrote:
Karen Hill wrote:
Alvaro Herrera wrote:
Karen Hill wrote:
It would be really great if PostgreSQL supported SQL:2003 Window
functions. I know that oracle and sql server have them already, so it
would make postgres
Bruce Momjian wrote:
Alvaro Herrera wrote:
Bruce Momjian wrote:
Karen Hill wrote:
Alvaro Herrera wrote:
Karen Hill wrote:
It would be really great if PostgreSQL supported SQL:2003 Window
functions. I know that oracle and sql server have them already, so
I looked at the TODO list at
http://www.postgresql.org/docs/faqs.TODO.html, and I don't see SQL:2003
Window Functions listed. Is it because they are not desired, or is it
because there are more pressing things to accomplish? I noticed that
Tom has mentioned that it appears unworkable in this
Alvaro Herrera wrote:
They are in the standard and have been mentioned many times.
Mentioned how? Window functions? I have seem people ask for them in
the past week, but never before that.
Yeah, window functions. I remember Chris Kings-Lynne mentioning them
since at least a year
I know that in pgsql.hackers they are discussing what to market the
upcoming 8.2 release as. They mention updatable views, but
realistically, PostgreSQL has had them via rules forever. I consider
myself a database novice , and even I've created updatable views using
rules quite easily.
It
Karen Hill wrote:
It would be really great if PostgreSQL supported SQL:2003 Window
functions. I know that oracle and sql server have them already, so it
would make postgres competitive in that area. I know there is a
feature freeze for 8.2, is it doable for 8.3?
The sooner you start
On Aug 24, 2006, at 14:11 , Alvaro Herrera wrote:
Karen Hill wrote:
It would be really great if PostgreSQL supported SQL:2003 Window
functions. I know that oracle and sql server have them already,
so it
would make postgres competitive in that area. I know there is a
feature freeze for
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of AgentM
Sent: Thursday, August 24, 2006 11:27 AM
To: PostgreSQL General ML
Subject: Re: [GENERAL] SQL:2003 Window Functions for postgresql 8.3?
On Aug 24, 2006, at 14:11 , Alvaro
On Thu, Aug 24, 2006 at 02:26:53PM -0400, AgentM wrote:
Could someone elaborate on the window functions? This page http://
en.wikipedia.org/wiki/SELECT has some examples but they make it seem
like the functions are an overly-verbose LIMIT statement. So what's
the benefit?
Look for more
Martijn van Oosterhout kleptog@svana.org writes:
The main thing I want to use them for is for cumulative output.
...
With window functions you define for each row a window which is from
the beginning of the table to that row and then sum the values, for
each row. Then you just divide by the
Postgres' DISTINCT ON clause is an example of a window function, though as
it stands today it seems to be a special-case hack, instead of an example
of a more generalized feature.
On Thu, 24 Aug 2006, AgentM wrote:
On Aug 24, 2006, at 14:11 , Alvaro Herrera wrote:
Karen Hill wrote:
It
On Thu, Aug 24, 2006 at 02:47:20PM -0400, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
The main thing I want to use them for is for cumulative output.
...
With window functions you define for each row a window which is from
the beginning of the table to that row and
Tom Lane wrote on 24.08.2006 20:47:
Perhaps an extremely smart optimizer could improve this using knowledge
of the specific aggregates' behaviors, but for black box aggregates
it sounds pretty unworkable.
I don't know how they do it, but those functions in Oracle are pretty fast.
Usually ways
Clinging to sanity, [EMAIL PROTECTED] (Tom Lane) mumbled into her beard:
Martijn van Oosterhout kleptog@svana.org writes:
The main thing I want to use them for is for cumulative output.
...
With window functions you define for each row a window which is from
the beginning of the table to that
18 matches
Mail list logo