On 08/11/2010 02:39 PM, David E. Wheeler wrote:
> On Aug 11, 2010, at 11:35 AM, Andrew Dunstan wrote:
>
>>> for i in select array_subscripts(myarray, 1) loop ...
>> That's not a built-in function AFAIK.
> Pavel pointed out to me only yesterday that it is:
>
> http://www.postgresql.org/docs/current/static/functions-srf.html#FUNCTIONS-SRF-SUBSCRIPTS
>
>
except that you mis-spelled it: It's generate_subscripts(), not
array_subscripts().
I guess I must have missed that in the 8.4 features.
cheers
andrew