Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.8.8/8.7.5) with ESMTP id JAA23176 for ; Wed, 2 Sep 1998 09:25:05 -0400 (EDT) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.8.6/8.8.6/NETTuno 3.1) with ESMTP id PAA01085; Wed, 2 Sep 1998 15:24:56 +0200 (MDT) Received: from blu.sferacarta.com (mail.sferacarta.com) [10.20.30.12] by proxy.sferacarta.com with smtp (Exim 1.92 #1 (Debian)) id 0zEDsT-0001Dh-00; Wed, 2 Sep 1998 14:27:17 +0000 Date: Wed, 2 Sep 1998 14:33:28 +0200 From: Sferacarta Software X-Mailer: The Bat! (v1.017) UNREG Reply-To: Sferacarta Software Organization: Sferacarta Software Priority: Normal Message-ID: <4606.980902@bo.nettuno.it> To: pgsql-sql@postgresql.org, Maarten Boekhold , M.Boekhold@et.tudelft.nl Subject: Re: [SQL] upper() and lower() on varchar References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Hello Maarten, marted́, 1 settembre 98, you wrote: MB> Hi, MB> Is there a way to get upper() and lower() to work on a varchar column? It MB> seems like these functions are only defined on the text datatype (in 6.3.2). MB> I guess what I need in this case is some way to convert varchar to text. MB> Will (text_in(varchar_out(column)) work? MB> Maarten MB> _____________________________________________________________________________ MB> | TU Delft, The Netherlands, Faculty of Information Technology and Systems | MB> | Department of Electrical Engineering | MB> | Computer Architecture and Digital Technique section | MB> | M.Boekhold@et.tudelft.nl | MB> ----------------------------------------------------------------------------- It works for me (6.3.2) take a look: create table a(a varchar(10)); insert into a values ('AAA'); insert into a values ('aaa'); select * from tbl; fld --- aaa AAA (2 rows) select * from tbl where upper(fld)='AAA'; fld --- aaa AAA (2 rows) Best regards, Jose' mailto:sferac@bo.nettuno.it