Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.python > #63800

Re: efficient way to process data

Subject Re: efficient way to process data
From Petite Abeille <petite.abeille@gmail.com>
Date 2014-01-12 20:53 +0100
References <CACwCsY6KBDVkS5jCMh9GyvhHyVgqcAH3YAYnGpMQvfBwexaTcw@mail.gmail.com>
Newsgroups comp.lang.python
Message-ID <mailman.5385.1389557901.18130.python-list@python.org> (permalink)

Show all headers | View raw


On Jan 12, 2014, at 8:23 PM, Larry Martell <larry.martell@gmail.com> wrote:

> AFAIK, there is no way to do this in SQL.

Sounds like a job for window functions (aka analytic functions) [1][2].

[1] http://www.postgresql.org/docs/9.3/static/tutorial-window.html
[2] http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions004.htm#SQLRF06174

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread


Thread

Re: efficient way to process data Petite Abeille <petite.abeille@gmail.com> - 2014-01-12 20:53 +0100

csiph-web