IF- statements in a rule's 'DO INSTEAD SELECT ...'- statement

Поиск
Список
Период
Сортировка
От Bertin, Philippe
Тема IF- statements in a rule's 'DO INSTEAD SELECT ...'- statement
Дата
Msg-id B9E404D03707D511BD4D00105A40C10466B56E@wevmex01.barco.com
обсуждение исходный текст
Ответы Re: IF- statements in a rule's 'DO INSTEAD SELECT ...'-  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Список pgsql-general
Hello, all,

Can I insert IF- statements into a rule's DO INSTEAD- clause ? I have the
problem in a situation like :

create rule vprinsert as on insert to vpr_status
        do instead (DDDDD);

if I insert as DDDDD a genuine SELECT- statement (or, Alvaro, several select
statements), everything is OK; but if I start inserting IF- statements, it's
not OK any more (syntax errors). Don't I just know the exact syntax, or is
this simply impossible ?

Anyone any idea on how to resolve this ?

Regads,

Philippe Bertin.

P.S. To have an idea why I want to insert IF- statements into the rule,
please refer to my newsgroup posting of last Friday ...

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

Предыдущее
От: Erwin Ambrosch
Дата:
Сообщение: Foreign Key Option
Следующее
От: Feng-Cheng Chang
Дата:
Сообщение: FATAL error after a system crash