insert into view

From: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
To: "postgres" <pgsql-general(at)postgresql(dot)org>
Subject: insert into view
Date: 2002-10-06 17:42:56
Message-ID: 00bb01c26d5f$ce76ad40$aa0f5ac2@canaan.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

im trying to insert into the following view and i have problem handeling the
serial type

CREATE TABLE a (field11 serial PRIMARY KEY,field12 integer);
CREATE TABLE b (field11 integer REFERENCES field11, field22 integer PRIMARY
KEY)

CREATE VIEW some_view AS
SELECT * FROM a,b left join b using (field11);

CREATE RULE insert_into_view AS ON INSERT TO some_view DO INSTEAD (
INSERT INTO a (field12) VALUES (NEW.field11);
INSERT INTO b (field11, field22) VALUES (NEW.field11, NEW.field22);
);

now.

how do i tell him the second insert in the rule to use the new value of the
serial from the first insert ?

Thanks in advance

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Aasmund Midttun Godal 2002-10-06 17:47:51 Re: insert into view
Previous Message Curt Sampson 2002-10-06 15:52:24 Re: [HACKERS] Performance while loading data and indexing