Re: [GENERAL] Substitute a variable in PL/PGSQL.

artacus@comcast.net wrote:

>You can do it in straight sql like so.
>
>SELECT (array[col1, col2, col3, col4, col5, col6, col7, col8, col9, col10])[i]
>FROM test t, generate_series(1,10) i
>
>Art
>
>
>
Hi Art,
Thanks for the advice, in my case using arrays was not a option as the
data could be null.
Steve M.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general