> On Wed, Aug 12, 2009 at 08:45:58PM -0700, Scott Bailey wrote:
>> CREATE OR REPLACE FUNCTION unnest(anyarray)
>> RETURNS SETOF anyelement AS
>> $BODY$
>> SELECT $1[i] FROM
>> generate_series(array_lower($1,1),
>> array_upper($1,1)) i;
>> $BODY$
>> LANGUAGE 'sql' IMMUTABLE STRICT
>
> I'd recommend taking off the "STRICT" from this. It will, counter
> intuitively, slow things down when you're not expecting it.
>
Woah! Really? I use strict a lot when it doesn't make sense to process a
function with a null param. Can you give me more details or point me to
more reading on this issue? Thanks.