Received: from mx99.openu.ac.il (arbel.openu.ac.il [147.233.32.4]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA09187 for ; Mon, 3 May 1999 12:01:44 -0400 (EDT) (envelope-from herouth@oumail.openu.ac.il) Received: from talmon.openu.ac.il (talmon.openu.ac.il [147.233.32.11]) by mx99.openu.ac.il (Postfix) with ESMTP for id 667194B5F2; Mon, 3 May 1999 19:01:42 +0300 (IDT) Received: from [147.233.159.109] (mac-herouth.pc.openu.ac.il) by talmon.openu.ac.il (Netscape Messaging Server 3.54) with ESMTP id AAA6D49; Mon, 3 May 1999 19:03:54 +0300 X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <01BE9558.BC2A44E0.jt-kirkpatrick@mpsllc.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Mon, 3 May 1999 19:02:15 +0300 To: JT Kirkpatrick , "'pgsql-sql@hub.org'" From: Herouth Maoz Subject: Re: [SQL] convert text to varchar At 18:33 +0300 on 03/05/1999, JT Kirkpatrick wrote: > hi! i have a text field (table ap3, field name apnote) that i would like > to insert into a varchar field (same field name, table name ap). any idea > why this doesn't work? insert into ap (apnote) select varchar('apnote') > from ap3; -- it fails with or without the single quotes. Should be simply INSERT INTO ap (apnote) SELECT ap3.apnote FROM ap3; You really shouldn't have single quotes, and the conversion to text is supposed to be automatic. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma