create rule

From: "Jose' Soares" <jose(at)sferacarta(dot)com>
To: "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: create rule
Date: 1998-12-31 09:08:11
Message-ID: 368B3EFB.777C14BC@sferacarta.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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'-

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrey V Khavryutchenko 1998-12-31 10:39:15 Re: [HACKERS] problems recovering 6.1 db
Previous Message Vadim Mikheev 1998-12-31 05:37:48 Happy New Year!