Re: aggregate function for median calculation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org, Peter Eisentraut <peter_e(at)gmx(dot)net>, Alex Pilosov <alex(at)pilosoft(dot)com>
Subject: Re: aggregate function for median calculation
Date: 2001-06-21 16:47:24
Message-ID: 17112.993142044@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Thalis A. Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu> writes:
> I worked on it so the struct state now has 3 fields: int length, int
> elem_count, int *elements. Now the issue is that the transition
> function, which I declare as strict, has a different input and state
> type (int4 and text respectively), so it requires an INITCOND. What
> should that be?

You're going to have to make your code able to start from a value that
can be represented as an INITCOND. Say, an empty string (zero length
word and nothing else). You're cheating, remember?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stock, Stuart H. 2001-06-21 17:14:41 Error: cannot write block XX of XXXXX/XXXXX blind: resource tempo rarily unavailable
Previous Message Thalis A. Kalfigopoulos 2001-06-21 16:10:11 Re: aggregate function for median calculation