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 <sam@samason.me.uk>) |
| Ответы |
Re: Looping through string constants
|
| Список | pgsql-general |
> 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 по дате отправления: