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.
--
Sam http://samason.me.uk/