Обсуждение: 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) #