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 по дате отправления:

Предыдущее
От: "Phoenix Kiula"
Дата:
Сообщение: Re: Yet Another COUNT(*)...WHERE...question
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Yet Another COUNT(*)...WHERE...question