| From: | Andreas Fromm <Andreas(dot)Fromm(at)physik(dot)uni-erlangen(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | inserting via "on insert" rule |
| Date: | 2003-09-01 20:09:45 |
| Message-ID: | 3F53A789.8060200@physik.uni-erlangen.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I have a table, say "person", where I store all the information of the
people I have in my files. I have a subgroup of people, say "users",
which I want to store on the same table "persons" by imposing some
restricitons on some columns.
I was thinking of defining a view "users" over "persons" which would let
me retrive the list of useres. But How would I implement the rule for
insertiung users? I tryed the following but NEW is not known where I
want to use it:
CREATE VIEW users AS
SELECT * FROM persons WHERE is_user(person.id) = TRUE;
CREATE RULE insert_on_users AS ON INSERT
TO users DO INSTEAD
INSERT INTO persons SELECT * FROM NEW;
The other thing I don't know is how to enforce the aditional constraints
that qualify as user when inserting to users. Of course I could do it on
the application side, but I would like to have it on the database too.
Any suggestions will be appreciated.
Regards,
Andreas Fromm
| From | Date | Subject | |
|---|---|---|---|
| Next Message | darren | 2003-09-01 20:25:05 | Re: Field collection in trigger |
| Previous Message | apb18 | 2003-09-01 20:08:14 | Re: Field collection in trigger |