Received: from ucs.co.za (ucsns.ucs.co.za [196.23.43.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e639XmS93720 for ; Mon, 3 Jul 2000 05:33:49 -0400 (EDT) Received: from ucspost.ucs.co.za (IDENT:root@mailgw1.ucs.co.za [196.23.43.254]) by ucs.co.za (8.9.3/8.9.3) with ESMTP id LAA18220; Mon, 3 Jul 2000 11:38:53 +0200 Received: from jhb.ucs.co.za (IDENT:root@jhb.ucs.co.za [172.31.1.73]) by ucspost.ucs.co.za (8.9.3/8.7.3) with ESMTP id LAA18589; Mon, 3 Jul 2000 11:37:41 +0200 Received: from ucs.co.za (IDENT:gaf@pc141.ucs.co.za [172.31.1.141]) by jhb.ucs.co.za (8.9.3/8.8.7) with ESMTP id LAA28563; Mon, 3 Jul 2000 11:33:28 +0200 Message-ID: <39605E36.589B6F35@ucs.co.za> Date: Mon, 03 Jul 2000 11:34:46 +0200 From: Grant Finnemore X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.12-20 i686) X-Accept-Language: en MIME-Version: 1.0 To: "Anatoly K. Lasareff" CC: Emils Klotins , pgsql-sql@postgresql.org Subject: Re: trigger or something else? References: <3959EFA4.13956.28AD4E96@localhost> <87bt0mkr7y.fsf@tolikus.hq.aaanet.ru> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200007/14 > I suppose you can use view for your need. For example: > ... > Unfortunately this way suits for select only, not for 'insert into b' > and 'update b' statement. > Except that you can use rules to update/insert data into tables when an insert/update is done on the view. See the docs for details on how to do this. > > -- > Anatoly K. Lasareff Email: tolik@aaanet.ru Grant -- > Poorly planned software requires a genius to write it > and a hero to use it. Grant Finnemore BSc(Eng) (mailto:gaf@ucs.co.za) Software Engineer Universal Computer Services Tel (+27)(11)712-1366 PO Box 31266 Braamfontein 2017, South Africa Cell (+27)(82)604-5536 20th Floor, 209 Smit St., Braamfontein Fax (+27)(11)339-3421 Johannesburg, South Africa