Received: from corppo1.uvsg.com (corppo1.uvsg.com [192.40.65.90]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA05814 for ; Mon, 3 May 1999 11:39:02 -0400 (EDT) (envelope-from michael.j.davis@tvguide.com) Received: from prevuepo1.prevuenet.com (prevuepo1.uvsg.com [192.40.65.44]) by corppo1.uvsg.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2448.0) id J5RFXM14; Mon, 3 May 1999 10:38:38 -0500 Received: by prevuepo1.uvsg.com with Internet Mail Service (5.5.2232.9) id ; Mon, 3 May 1999 10:41:39 -0500 Message-ID: <93C04F1F5173D211A27900105AA8FCFC145464@lambic.prevuenet.com> From: Michael J Davis To: "'JT Kirkpatrick'" , "'pgsql-sql@hub.org'" Subject: RE: [SQL] convert text to varchar Date: Mon, 3 May 1999 10:34:34 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain try: insert into ap (apnote) select apnote::varchar from ap3; > -----Original Message----- > From: JT Kirkpatrick [SMTP:jt-kirkpatrick@mpsllc.com] > Sent: Monday, May 03, 1999 9:33 AM > To: 'pgsql-sql@hub.org' > Subject: [SQL] convert text to varchar > > 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