Function ROWTYPE Parameter with NEW/OLD

Поиск
Список
Период
Сортировка
От Andrew Milne
Тема Function ROWTYPE Parameter with NEW/OLD
Дата
Msg-id 001501c3ad35$d46708a0$8d101cac@solutionip.com
обсуждение исходный текст
Список pgsql-sql
Postgres 7.2.1

I'm trying to create a function that takes a ROWTYPE parameter that I can
then call from a rule by passing NEW/OLD, but am having problems.


CREATE OR REPLACE FUNCTION "some_boolean_function" (mytablename) RETURNS
boolean AS '       DECLARE               mytable ALIAS FOR $1;       BEGIN              -- IF SOME CONDITION RETURN
TRUEELSE RETURN FALSE;       END;'       LANGUAGE 'plpgsql';
 

This works fine.

CREATE RULE some_rule AS ON UPDATE TO mytablename WHERE
(some_boolean_function(new, old)) DO INSTEAD (some other statements);

It cacks on the new and old parameters - misunderstanding on my part?
potential bug?  I have to check most of the fields in this table, so would
rather pass the whole record rather than individual fields.

Thanks,

Andrew



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

Предыдущее
От: Yasir Malik
Дата:
Сообщение: Re: Addition and subtraction on BIT type
Следующее
От: "Randolf Richardson, DevNet SysOp 29"
Дата:
Сообщение: Re: Array fields in Postgresql...