Re: Function can not use the 'NEW' variable as a direct parameter inside trigger function?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Function can not use the 'NEW' variable as a direct parameter inside trigger function?
Дата
Msg-id 1404954.1712344870@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [MASSMAIL] Function can not use the 'NEW' variable as a direct parameter inside trigger function?  (intmail01 <intmail01@gmail.com>)
Список pgsql-sql
intmail01 <intmail01@gmail.com> writes:
> Why a function can not pass the 'NEW' variable as a direct parameter ?
> When I use myFunction(NEW) inside a trigger function an error appears :

> pq_driver: [PGRES_FATAL_ERROR]ERROR:  function myFunction(MyTableStruct)
> does not exist
> LINE 1: ...myFunction(NEW)...
>               ^
> HINT:  No function matches the given name and argument types. You might
> need to add explicit type casts.

That doesn't look like NEW's fault.  You lack a suitable function
to be called.

            regards, tom lane



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

Предыдущее
От: intmail01
Дата:
Сообщение: [MASSMAIL] Function can not use the 'NEW' variable as a direct parameter inside trigger function?
Следующее
От: kunwar singh
Дата:
Сообщение: How to pass arguments in postgres to sql scripts.