Re: [INTERFACES] Pgtcl: pg_result numeric indices

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kambiz Darabi <darabi(at)nc(dot)klinik(dot)uni-mainz(dot)de>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] Pgtcl: pg_result numeric indices
Date: 1999-10-19 01:02:37
Message-ID: 27761.940294957@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Kambiz Darabi <darabi(at)nc(dot)klinik(dot)uni-mainz(dot)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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Victoria W. 1999-10-19 06:17:39
Previous Message Bruce Stephens 1999-10-18 19:25:29 Re: [INTERFACES] Support for Tcl/Tk 8.2