agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Olivier Leprêtre <o.lepretre@gmail.com>
To: pgsql-sql@lists.postgresql.org
Subject: window function ?
Date: Sun, 10 Dec 2017 19:33:54 +0100
Message-ID: <5a2d7e15.841a1c0a.ad030.7447@mx.google.com> (raw)
Hi,
I have a table containing sort of boxes in different categories described by
three columns categorie/box/count
In each categorie, I want to associate each box with the count of the others
(sum of counts of this categorie but not the current one).
As an example :
cat box count
cat1 box21 2
cat1 box23 6
cat1 box34 1
cat1 box37 3
cat3 box45 12
cat3 box62 2
cat3 box89 7
cat3 box12 9
cat3 box28 10
cat8 box02 10
cat8 box87 2
cat8 box46 3
will return
cat1 box21 2 10 (6+1+3) => 2 not added
cat1 box23 6 6 (2+1+3) => 6 not added
cat1 box34 1 11 (2+6+3) => 1 not added
cat1 box37 3 9 (2+6+1) => 3 not added
cat3 box45 12 28 (2+7+9+10)
cat3 box62 2 38 (12+7+9+10)
cat3 box89 7 33 (12+2+9+10)
cat3 box12 9 31 (12+2+7+10)
cat3 box28 10 30 (12+2+7+9)
cat8 box02 10 5 (2+3)
cat8 box87 2 13 (10+3)
cat8 box46 3 12 (10+2)
I searched thru lateral and window functions but didn't manage to do that.
thanks for any help.
Olivier
---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus
view thread (2+ messages) latest in thread
Message-ID: <5a2d7e15.841a1c0a.ad030.7447@mx.google.com>
Permalink: ../5a2d7e15.841a1c0a.ad030.7447@mx.google.com/
Also on: postgresql.org/message-id/5a2d7e15.841a1c0a.ad030.7447@mx.google.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: o.lepretre@gmail.com, pgsql-sql@lists.postgresql.org
Subject: Re: window function ?
In-Reply-To: <5a2d7e15.841a1c0a.ad030.7447@mx.google.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox