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])

Reply via email to