Array in stored procedure

From: Michal Hlavac <hlavki(at)medium13(dot)sk>
To: pgsql-general(at)postgresql(dot)org
Subject: Array in stored procedure
Date: 2004-02-02 08:37:39
Message-ID: 401E0C53.8010608@medium13.sk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

DECLARE
groups integer[];
tmp RECORD;
tmpi integer;
BEGIN
FOR tmp IN SELECT i_group_id FROM l_group_to_user WHERE i_user_id =
$1 LOOP
SELECT i_group_id INTO tmpi FROM s_group WHERE i_group_id =
tmp.i_group_id;
groups[] := tmpi;
RETURN NEXT tmp.i_group_id;
END LOOP;
RETURN NULL;
END

hello,

I am using v7.3.5. I cannot fill and use array "groups". It is possible
in stored procedures???
Row: groups[] := tmpi;
returns error: syntax error at or near "["
thanx... miso

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2004-02-02 09:13:46 Re: How to kick out automatically stuck in queries
Previous Message Együd Csaba 2004-02-02 08:29:44 How to kick out automatically stuck in queries