Обсуждение: Pgtcl: pg_result numeric indices

Поиск
Список
Период
Сортировка

Pgtcl: pg_result numeric indices

От
Kambiz Darabi
Дата:
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
--


Re: [INTERFACES] Pgtcl: pg_result numeric indices

От
Tom Lane
Дата:
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