PL/PgSQL and arrays

Поиск
Список
Период
Сортировка
От Michael Samuel
Тема PL/PgSQL and arrays
Дата
Msg-id 20010727152116.B20960@hal9000.hyperlink.net.au
обсуждение исходный текст
Список pgsql-general
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
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Re: Running Postmaster - PGDATA Variable
Следующее
От: Tom Lane
Дата:
Сообщение: Re: What's going on here?