Instaltiating an ARRAY within a function

From: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Instaltiating an ARRAY within a function
Date: 2007-12-12 12:48:18
Message-ID: E9DE7963E5EA6546B42A979EC28B4D0136B28ED5@hou-ex-02.adprod.bmc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lawrence Oluyede 2007-12-12 12:57:28 Re: Possible bug in PostgreSQL 8.3beta4 (postgres process segfaults)
Previous Message Ashish Karalkar 2007-12-12 12:44:09 Re: very slow query