Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA04506 for ; Mon, 3 May 1999 11:31:13 -0400 (EDT) (envelope-from jt-kirkpatrick@mpsllc.com) Received: from kirkpatrickjt (whiteoak-34.highertech.net [209.140.56.34] (may be forged)) by s20.highertech.net (8.8.6/8.8.6) with SMTP id LAA09427 for ; Mon, 3 May 1999 11:30:56 -0400 Received: by localhost with Microsoft MAPI; Mon, 3 May 1999 11:33:15 -0400 Message-ID: <01BE9558.BC2A44E0.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'pgsql-sql@hub.org'" Subject: convert text to varchar Date: Mon, 3 May 1999 11:33:14 -0400 Organization: MPS, LLC X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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. TIA, jt