Обсуждение: create rule

Hi all,

Seems that no one of the examples on 'man create_rule' does works.
What about to try every example on man pages?
Seems that's posssible to create a rule on event SELECT only to define
views
Am I wrong ?

I'm trying to create a rule like this:

create rule my_rule ason select to employeesdo instead select INITCAP(ename),       UPPER(empno,       UPPER(job),
hiredate,       sal,       comm,       deptno,       level,       mgrfrom employees;
 

Any ideas?

Thanks,

-Jose'-

>
> Hi all,
>
> Seems that no one of the examples on 'man create_rule' does works.
> What about to try every example on man pages?
> Seems that's posssible to create a rule on event SELECT only to define
> views
> Am I wrong ?

    You're  right  and  the man page for CREATE RULE is outdated.
    Rules on  the  SELECT  event  are  100%  restricted  to  view
    definitions  now  (one  single  instead  action  that selects
    exactly the same  attribute  types  and  names  the  relation
    itself has).

    I must still update that man page, thanks.

    In  the  meantime  you  might want to take a look at the rule
    system documentation of the programmers  manual,  which  I've
    written  entirely  from  scratch  after the fixes to the rule
    system for v6.4.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #