Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id VAA48358
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 18 Oct 1999 21:03:19 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id VAA27764;
	Mon, 18 Oct 1999 21:02:37 -0400 (EDT)
To: Kambiz Darabi <darabi@nc.klinik.uni-mainz.de>
cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Pgtcl: pg_result numeric indices 
In-reply-to: Your message of Sun, 17 Oct 1999 21:12:25 +0200 (CEST)
	<m11cvjF-000jHqC@avicenna.nc.klinik.uni-mainz.de>
Date: Mon, 18 Oct 1999 21:02:37 -0400
Message-ID: <27761.940294957@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Kambiz Darabi <darabi@nc.klinik.uni-mainz.de> writes:
> I quite often use 
> pg_result -assign arrayname
> It does a great job, but I would badly need an array with
> numeric indices:
> arrayname(0,0) instead of arrayname(0,qty)
> First number is row number, second one column number.
> Is there a way of doing this (besides reformatting the array 
> with array get and array set) ?

Have you thought about labeling the columns with the subscripts
you want?

SELECT col1 AS "0", col2 AS "1", ...

			regards, tom lane