[EMAIL PROTECTED] 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
