Re: [INTERFACES] Pgtcl: pg_result numeric indices - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [INTERFACES] Pgtcl: pg_result numeric indices
Date
Msg-id 27761.940294957@sss.pgh.pa.us
Whole thread Raw
In response to Pgtcl: pg_result numeric indices  (Kambiz Darabi <darabi@nc.klinik.uni-mainz.de>)
List pgsql-interfaces
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


pgsql-interfaces by date:

Previous
From: Bruce Stephens
Date:
Subject: Re: [INTERFACES] Support for Tcl/Tk 8.2
Next
From: "Victoria W."
Date:
Subject: ...