Re: Looping through string constants

Поиск
Список
Период
Сортировка
Искать
От
Scott Bailey
Тема
Re: Looping through string constants
Дата
Msg-id
4A84317F.5010709@comcast.net
Ответ на
Список
Дерево обсуждения
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 по дате отправления
От: Scara Maccai
Дата:
От: Sam Mason
Дата:
FAQ