Re: Looping through string constants

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/