Home > mailing lists

Re: Substitute a variable in PL/PGSQL. - Mailing list pgsql-general

From	artacus@comcast.net
Subject	Re: Substitute a variable in PL/PGSQL.
Date	July 23, 2008 06:19:03
Msg-id	072320080601.27438.4886C94C0006199F00006B2E22155751149C9A0C0E9B9D0E@comcast.net Whole thread Raw
In response to	Substitute a variable in PL/PGSQL. (Steve Martin <steve.martin@nec.co.nz>)
List	pgsql-general

Tree view

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

pgsql-general by date:

From: Chris
Date: 23 July 2008, 04:31:03
Subject: Re: pg_query transaction: auto rollback? begin or start?? commit or end???

From: Karsten Hilbert
Date: 23 July 2008, 07:02:52
Subject: Re: pg_query transaction: auto rollback? begin or start?? commit or end???

Re: Substitute a variable in PL/PGSQL. - Mailing list pgsql-general

Previous

Next