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 as
 on select to employees
 do instead select INITCAP(ename),
        UPPER(empno,
        UPPER(job),
        hiredate,
        sal,
        comm,
        deptno,
        level,
        mgr
 from employees;

Any ideas?

Thanks,

-Jose'-

Thu, 31 Dec 1998 10:08:11 +0100
"Jose' Soares" <jose@sferacarta.com>
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 ?

    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) #



Mon, 4 Jan 1999 10:21:26 +0100 (MET)
jwieck@debis.com (Jan Wieck)
Re: [HACKERS] create rule