Обсуждение: Pgtcl: pg_result numeric indices
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) ? Thanks Kami -- K. Darabi, M.D. Neurosurgery Johannes Gutenberg University Medical School Mainz, Germany Phone: +49-(0)-6131-17-7331 Fax: +49-(0)-6131-17-2274 --
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