Create custom aggregate function and custom sfunc

From: Jasmin Dizdarevic <jasmin(dot)dizdarevic(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Create custom aggregate function and custom sfunc
Date: 2009-07-02 14:48:50
Message-ID: a0eee4d40907020748p7cb9bad7mad8817e60e9ea89@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

hi,

i have to create a aggregate function which evaluates a maximum text
value but with some conditions i have to take care of.
is there a way to access a value set of each group?
e.g.:

customer ; seg
111 ; L1
111 ; L2
111 ; L1
222 ; L3
222 ; L3
222 ; L2

the result should look like this:

111: L1 - because L1 is higher than L2 and ratio of L1 : L2 is 2 : 1
222: L3 - because L3 is higher than L2 and ratio of L3 : L2 is 2 : 1

i hope you know what i mean.

ty

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message justin 2009-07-02 17:37:28 Re: Create custom aggregate function and custom sfunc
Previous Message Tim Haak 2009-07-02 09:31:04 Re: Partitioned tables not using index for min and max 8.2.7?