X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 69A01475843 for ; Wed, 19 Feb 2003 02:39:56 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id A2C7847580B for ; Wed, 19 Feb 2003 02:39:55 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h1J7ds5u009356; Wed, 19 Feb 2003 02:39:55 -0500 (EST) To: "Martin Davidsson" Cc: pgsql-sql@postgresql.org Subject: Re: Rule Creates Duplicates retry In-reply-to: <000501c2d777$2a0e1040$62400798@martin> References: <000501c2d777$2a0e1040$62400798@martin> Comments: In-reply-to "Martin Davidsson" message dated "Tue, 18 Feb 2003 12:57:12 -0500" Date: Wed, 19 Feb 2003 02:39:54 -0500 Message-ID: <9355.1045640394@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/420 X-Sequence-Number: 11818 "Martin Davidsson" writes: > I then create a rule to seperate these logs into more > logical columns, like this: > create rule split_log as on insert to messyTable where message like > '%website.url%' do insert into cleanTable values ( > split_part(syslogtb.message,' | ',1), > split_part(syslogtb.message,' | ',2), > ..... > split_part(syslogtb.message,' | ',n) > ); Not certain, but I think you want to be referring to NEW.message, not messyTable.message (assuming syslogtb is what you meant by messyTable...). If you don't refer to NEW then you are likely to get some bizarre join-of-existing-rows behavior out of this. regards, tom lane