From: | "James F" <nospam_james(at)hcjb(dot)org(dot)ec> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | array variables |
Date: | 2002-12-16 16:45:46 |
Message-ID: | 000801c2a522$956831e0$3b0010ac@jfreezexp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am writing a pl/pgsql function that needs to use an array. I can find precious little documentation of the use of arrays, especially in postgresql's official documentation. Is there any comprehensive documentation for plpgsql syntax (not just arrays but all areas)? For example, I have found code examples that use the _arrayvar syntax, but I want to know where these programmers figured this out as I can't find it on postgresql.org.
In the meanwhile, how do I declare an array of fixed length and then later reference it to assign a value to an array item?
James F.
From | Date | Subject | |
---|---|---|---|
Next Message | Frank van Vugt | 2002-12-16 16:45:59 | v7.3 : \encoding doesn't show changes in client encoding that are not done with \encoding itself (i.e. set names/set client_encoding) |
Previous Message | Harald Krake | 2002-12-16 16:32:34 | prepared statements and analyze in 7.3 |