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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
