[GENERAL] Instaltiating an ARRAY within a function

[Abraham, Danny]

===========================================

CREATE OR REPLACE FUNCTION arr( inout x varchar[] )
AS
$Z$
DECLARE
  i integer;
BEGIN
select ARRAY['Danny','Eissam','Moshe'] into x;
end;
$Z$ LANGUAGE 'plpgsql' VOLATILE;

===========================================

CREATE OR REPLACE FUNCTION callarr()
returns integer
AS
$Z$
DECLARE
  x varchar[6]; 
BEGIN
perform arr(x);
RAISE NOTICE 'x[1]=%',x[1];
return 0;
end;
$Z$ LANGUAGE 'plpgsql' VOLATILE;

===========================================

select callarr();
NOTICE:  x[1]=<NULL>  ??? Should have been DANNY


Should it work?

Thanks

Danny

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings