Re: plpgsql Field of Record issue

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: plpgsql Field of Record issue
Дата
Msg-id 02ac01c1c2fc$4d136b70$8001a8c0@jester
обсуждение исходный текст
Ответ на plpgsql Field of Record issue  ("Rod Taylor" <rbt@zort.ca>)
Список pgsql-hackers
> "Rod Taylor" <rbt@zort.ca> writes:
> > Is there any other way to accomplish NEW.TG_ARGV[0] in plpgsql,
>
> You could do something involving EXECUTE.

Then it tells me:: ERROR: NEW used in non-rule query

Tried a few other things, FOR .. IN EXECUTE .. which gives the same
error as above.

The below query gives me the same error as well -- though I'd be
surprised if it worked anyway:
CREATE TEMP TABLE test AS SELECT * FROM (NEW);

Creating a record and assigning NEW to it gives a parse error.



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Status of index location patch
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: elog() patch