Bruno Wolff III <[EMAIL PROTECTED]> writes: > If someone did a naive implementation of first() and last() aggregates > for 8.1, is that something that would likely be accepted?
You mean like this? CREATE FUNCTION first_accum(anyelement,anyelement) RETURNS anyelement as 'select coalesce($1,$2)' LANGUAGE SQL; CREATE AGGREGATE first (BASETYPE=anyelement, SFUNC=first_accum, STYPE = anyelement); Though I suspect it would be faster as a native C implementation. -- greg ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])