Обсуждение: PL/PgSQL and arrays

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

PL/PgSQL and arrays

От
Michael Samuel
Дата:
Hi,

I'm trying to write a simple function in PL/PgSQL, that requires 2 int8s
worth of state.

In the manual, it suggests using an array to pass the data along, but I
can't figure out how to either declare an array, or to return an array
from within the function. (The usual syntax doesn't work)

Thanks in advance,
  Michael

BTW, I've tried writing it in pltcl, but it came out with weird results,
which appears to be as a result of TCL not supporting 64bit integers...

--
Michael Samuel
Tech Guy

michael@hyperlink.net.au

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Hyperlink, a division of The Swish Group Ltd
ACN 085 545 973
Level 6, 257 Collins St, Melbourne, VIC 3004
Phone 1300 368 638 Fax +61 3 9211 5406
http://www.hyperlink.net.au
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=