unnest with generate_subscripts and same array - Mailing list pgsql-general

From Carlos Fuentes
Subject unnest with generate_subscripts and same array
Date
Msg-id BANLkTik5DapyrqSE81VPG8vDbbW7kx_YuQ@mail.gmail.com
Whole thread Raw
Responses Re: unnest with generate_subscripts and same array  ("David Johnston" <polobo@yahoo.com>)
Re: unnest with generate_subscripts and same array  (David Fetter <david@fetter.org>)
List pgsql-general
Hello,
Given that these are the only one array_col in play, is
    select unnest(array_col), generate_subscripts(array_col) from table_with_array_col ;
guaranteed to gave the subscripts match the array element?  In all the testing I've done it's worked, but I don't know if I was just lucky :)

Thanks,
-Carlos Fuentes

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: max_connections proposal
Next
From: "David Johnston"
Date:
Subject: Re: unnest with generate_subscripts and same array