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.