Re: Looping through string constants
От
Scott Bailey
Тема
Re: Looping through string constants
Дата
Msg-id
4A84317F.5010709@comcast.net
Ответ на
Re: Looping through string constants (Sam Mason)
Список
Дерево обсуждения
Re: Looping through string constants Tim Landscheidt <tim@tim-landscheidt.de>
> 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.
В списке pgsql-general по дате отправления