Received: from pcr.ca (www.pcr.ca [207.139.158.13] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id OAA38833 for ; Tue, 18 Jan 2000 14:05:51 -0500 (EST) (envelope-from admin@wtbwts.com) Received: by pcr.ca (Postfix, from userid 1000) id 09BE91FEE; Tue, 18 Jan 2000 14:04:48 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by pcr.ca (Postfix) with ESMTP id EDF3D1FEC for ; Tue, 18 Jan 2000 14:04:48 +0000 (GMT) Date: Tue, 18 Jan 2000 14:04:48 +0000 (GMT) From: Marc Tardif X-Sender: admin@server.b0x.com To: pgsql-sql@postgresql.org Subject: char(19) to varchar(32) Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII I have created a rule to update a char(19) field from a varchar(32) field. I don't mind if half the field is cut out, I just want to copy the first 19 characters. Here's what I have ... update products set company=NEW.company; company is char(19); NEW.company is varchar(32); Any suggestions on making this work? Marc