Received: from Kitten.mcs.com (Kitten.mcs.com [192.160.127.90]) by hub.org (8.8.8/8.7.5) with ESMTP id OAA25709 for ; Tue, 15 Sep 1998 14:46:43 -0400 (EDT) Received: from Venus.mcs.net (les@Venus.mcs.net [192.160.127.92]) by Kitten.mcs.com (8.8.7/8.8.2) with ESMTP id NAA01177 for ; Tue, 15 Sep 1998 13:46:32 -0500 (CDT) Received: (from les@localhost) by Venus.mcs.net (8.8.7/8.8.2) id NAA19531 for pgsql-sql@postgreSQL.org; Tue, 15 Sep 1998 13:46:31 -0500 (CDT) From: Leslie Mikesell Message-Id: <199809151846.NAA19531@Venus.mcs.net> Subject: varchar vs. upper(), lower() etc. To: pgsql-sql@postgreSQL.org Date: Tue, 15 Sep 1998 13:46:31 -0500 (CDT) X-Mailer: ELM [version 2.4 PL24] Content-Type: text Is there a trick to making upper(), lower(), ~*, etc. work with varchar fields? Some things seem to work (select upper(field)), some don't (where upper(field) = upper(field)), and if I try the obvious casts to text, I get: ERROR: function text(varchar) does not exist. Should I just rebuild my database with text fields? I had initially used varchar so indexes would work through ODBC but it looks like that is working with text now. Les Mikesell les@mcs.com