Re: Substitute a variable in PL/PGSQL.

From: artacus(at)comcast(dot)net
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Substitute a variable in PL/PGSQL.
Date: 2008-07-23 06:01:48
Message-ID: 072320080601.27438.4886C94C0006199F00006B2E22155751149C9A0C0E9B9D0E@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2008-07-23 07:02:35 Re: pg_query transaction: auto rollback? begin or start?? commit or end???
Previous Message Chris 2008-07-23 03:15:30 Re: pg_query transaction: auto rollback? begin or start?? commit or end???