| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "David E(dot) Wheeler" <david(at)kineticode(dot)com>, Greg Stark <gsstark(at)mit(dot)edu>, Thom Brown <thom(at)linux(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: string_to_array with an empty input string |
| Date: | 2010-08-12 06:46:40 |
| Message-ID: | AANLkTine_q0e2KcEQ4PkaAvtKJxcVF1JWZEk3FfJocKY@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> Really?
>
> FOR var IN SELECT UNNEST(arr) LOOP ... END LOOP
>
> I mean, doing everything is sort of clunky in PL/pgsql, but this
> doesn't seem particularly bad as PL/pgsql idioms go.
>
this simple construction can take much more memory than other. I
proposed two or three years ago FOREACH statement
FOREACH var IN array LOOP END LOOP
this statement can be implemented very efective - and I think it can
be joined to some form of string_to_array function, because var
specify target element type.
FOREACH var IN parse('....',...) LOOP END LOOP
Regards
Pavel Stehule
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dimitri Fontaine | 2010-08-12 06:56:26 | Re: string_to_array with an empty input string |
| Previous Message | Pavel Stehule | 2010-08-12 06:26:43 | Re: review: psql: edit function, show function commands patch |