Function with Integer array parameter
От | Ranjan Kumar Baisak |
---|---|
Тема | Function with Integer array parameter |
Дата | |
Msg-id | 46C469D1.1010707@nyc.yamaha.com обсуждение исходный текст |
Ответы |
Re: Function with Integer array parameter
|
Список | pgsql-general |
Postgres Gurus, Please suggest me what is wrong with this function. This function tries to retrieve set of rows from description table based on set of ID fields passed as array. The error, I get is : ERROR: only one AS item needed for language "plpgsql" CREATE OR REPLACE function get_description_list(integer[]) RETURNS SETOF type_description AS 'DECLARE ints_desc_ids ALIAS FOR $1; desc_rec __i18n.type_description%ROWTYPE; BEGIN FOR desc_rec IN SELECT d_base.id AS description_id, ''en'' AS iso_lang, ''US'' AS iso_country_a2, 0 as description_type_id, d_base.description_text AS description_text FROM description AS d_base WHERE d_base.id in array_to_string(ints_desc_ids alias,',') LOOP RETURN NEXT desc_rec; END LOOP; RETURN; END;' LANGUAGE plpgsql;
В списке pgsql-general по дате отправления: