On Sep 1, 2010, at 11:52 AM, Pavel Stehule wrote: >> regression=# create or replace function array_agg_transfn_strict(internal, >> anyelement) returns internal as 'array_agg_transfn' language internal >> immutable; >> CREATE FUNCTION >> regression=# create aggregate array_agg_strict(anyelement) (stype = internal, >> sfunc = array_agg_transfn_strict, finalfunc = array_agg_finalfn); >> CREATE AGGREGATE >> regression=# create or replace function array_agg_transfn_strict(internal, >> anyelement) returns internal as 'array_agg_transfn' language internal strict >> immutable; >> CREATE FUNCTION >> > > nice dark trick :) - but it doesn't work > > ERROR: aggregate 16395 needs to have compatible input type and transition > type > postgres=#
I could use this trick now. Anyone got any bright ideas how to fix it? Thanks, David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
