Received: from Kitten.mcs.com (Kitten.mcs.com [192.160.127.90]) by hub.org (8.9.1/8.8.8) with ESMTP id NAA14802 for ; Sat, 24 Oct 1998 13:37:44 -0400 (EDT) (envelope-from les@Jupiter.mcs.net) Received: from Jupiter.mcs.net (les@Jupiter.mcs.net [192.160.127.88]) by Kitten.mcs.com (8.8.7/8.8.2) with ESMTP id MAA06548 for ; Sat, 24 Oct 1998 12:37:42 -0500 (CDT) Received: (from les@localhost) by Jupiter.mcs.net (8.8.7/8.8.2) id MAA29834 for pgsql-sql@postgreSQL.org; Sat, 24 Oct 1998 12:37:42 -0500 (CDT) From: Leslie Mikesell Message-Id: <199810241737.MAA29834@Jupiter.mcs.net> Subject: varchar vs. text To: pgsql-sql@postgreSQL.org Date: Sat, 24 Oct 1998 12:37:42 -0500 (CDT) X-Mailer: ELM [version 2.4 PL24] Content-Type: text Is there any way to apply the text functions to a varchar field or convert from varchar to text? I set up a database with varchar fields with unspecified sizes because at the time the odbc driver didn't like to use text as a unique key. Now pg_dump sets the size as (-5) which won't reload unless I take it out, and I can't use many of the text-style operators. Using field::text gives: 'ERROR: function text(varchar) does not exist'. Is there any reason to use varchar now that the ODBC driver works with text, and is there any way to convert short of pg_dump'ing and editing the structure? Les Mikesell les@mcs.com