Chris Angelico rosuav at gmail.com
Sun Jan 12 17:18:42 EST 2014

• Previous message (by thread): efficient way to process data
• Next message (by thread): efficient way to process data
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

---

On Mon, Jan 13, 2014 at 6:53 AM, Petite Abeille
<petite.abeille at gmail.com> wrote:
> On Jan 12, 2014, at 8:23 PM, Larry Martell <larry.martell at 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].

That's my thought too. I don't think MySQL has them, though, so it's
either going to have to be done in Python, or the database back-end
will need to change. Hard to say which would be harder.

ChrisA

---

• Previous message (by thread): efficient way to process data
• Next message (by thread): efficient way to process data
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

---

More information about the Python-list mailing list