PL/PgSQL and arrays

From: Michael Samuel <michael(at)hyperlink(dot)net(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: PL/PgSQL and arrays
Date: 2001-07-27 05:21:17
Message-ID: 20010727152116.B20960@hal9000.hyperlink.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hyperlink(dot)net(dot)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
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-07-27 05:56:49 Re: What's going on here?
Previous Message Philip Warner 2001-07-27 02:18:56 Re: Bad timestamp external representation