From: | woow <ruwanb(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Newbiee Pls help..... |
Date: | 2011-07-29 15:16:32 |
Message-ID: | 1311952592499-4647358.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have following function expectation is I want to return the items in array
so....I could call this from another function where I could traverse through
the each array element....
CREATE OR REPLACE FUNCTION get_role_id_list_for_type(INTEGER)
RETURNS INTEGER[] AS $$
DECLARE
rolelist INTEGER [];
BEGIN
SELECT INTO rolelist role_id FROM roles WHERE role_type = $1;
RETURN rolelist;
END;
$$ LANGUAGE 'plpgsql';
But when I call the function it gives following error......
ERROR: array value must start with "{" or dimension information
CONTEXT: PL/pgSQL function "get_role_id_list_for_type" line 4 at select
into variables
Could someone please help.....thanks so much in advance
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Newbiee-Pls-help-tp4647358p4647358.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2011-07-29 15:25:38 | Re: [PERFORM] Queries related to checkpoints |
Previous Message | Peter Eisentraut | 2011-07-29 14:32:01 | Re: query_to_xml nulls set to false |