Pro. Regarding Arrays.

Hello All,

I am Working on pgsqls user defined arrays.
if i am using arrays as l-value then '[]' doesnt give any error
but if i am trying to assign some value to any element of the array
then it gives error.
the function i am using as follows...

CREATE TYPE int_array_t (
INPUT = array_in,
OUTPUT = array_out,
INTERNALLENGTH = VARIABLE,
ELEMENT = int4
);

create function test_int_array()
returns int4 as

'declare
array_input int_array_t;
count int4;

begin
-- Initialize
count := 0;
array_input := ''{1, 2, 3}'';

while array_input[count + 1] IS NOT NULL
loop
count := count + 1;
count := array_input[count];
end loop;

return count;
end;'
/*
if i use array_input[Count]:=Count; then it gives compilation error

NOTICE: plpgsql: ERROR during compile of test_int_array near line 15
ERROR: parse error at or near "["
*/

Please guide me
Thanks
Pankaj

language 'plpgsql';

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.