Problems with GET DIAGNOSTICS SELECT PROCESSED INTO result;

Поиск
Список
Период
Сортировка
От Dr. Evil
Тема Problems with GET DIAGNOSTICS SELECT PROCESSED INTO result;
Дата
Msg-id 20010906204356.11975.qmail@sidereal.kz
обсуждение исходный текст
Ответы Solved! Re: Problems with GET DIAGNOSTICS SELECT PROCESSED INTO result;
Список pgsql-general
It doesn't seem to work as advertised:

DROP TABLE junk;
CREATE TABLE junk (something INT4);

DROP FUNCTION testfunction(INT4);
CREATE FUNCTION testfunction(INT4) RETURNS INT4 AS '
DECLARE
    result INT4;
BEGIN
    INSERT INTO junk (something) VALUES ($1);
    GET DIAGNOSTICS SELECT PROCESSED INTO result;
    RETURN result;
END;
' LANGUAGE 'plpgsql';

When I then run it I get:

=> select testfunction(10);
NOTICE:  plpgsql: ERROR during compile of testfunction near line 5
ERROR:  parse error at or near "SELECT"

Any idea how to get this to work?  This is with PG7.1.2.

Thanks

В списке pgsql-general по дате отправления:

Предыдущее
От: "Oliver Elphick"
Дата:
Сообщение: Re: Bug in createlang?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [ANNOUNCE] OSDN Announces Open Source Database Summit, September