Strugging with NEW and OLD records.

Поиск
Список
Период
Сортировка
От Script Head
Тема Strugging with NEW and OLD records.
Дата
Msg-id 451eb55c0511222348o33bbd5dbq785e1f6dc09ab7db@mail.gmail.com
обсуждение исходный текст
Ответы Re: Strugging with NEW and OLD records.  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
I am a newbie to the stored proc. game and this is eating my brain.

> CREATE TABLE name(first VARCHAR(32) NULL,last VARCHAR(32) NULL, extra VARCHAR(32) NULL );

> CREATE OR REPLACE FUNCTION update_name() RETURNS opaque AS '
    DECLARE
    BEGIN
   
        NEW.extra:=NEW.first;
        RETURN NEW;

    END;
' LANGUAGE 'plpgsql';

> CREATE TRIGGER update_name_extra BEFORE INSERT
ON name
EXECUTE PROCEDURE update_name();

> INSERT INTO name(first,last) VALUES('script','head');
ERROR:  record "new" is not assigned yet
DETAIL:  The tuple structure of a not-yet-assigned record is indeterminate.
CONTEXT:  PL/pgSQL function "update_name" line 4 at assignment

What am I doing wrong?

ScriptHead

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

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: tsearch2: more than one index per table?
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: tsearch2: more than one index per table?