Received: from fhcrc.org (bug1.fhcrc.org [140.107.10.110]) by hub.org (8.9.2/8.9.1) with ESMTP id PAA02378 for ; Thu, 28 Jan 1999 15:56:10 -0500 (EST) (envelope-from dnichols@fhcrc.org) Received: from snap.fhcrc.org (snap [140.107.49.11]) by fhcrc.org (8.9.1/8.9.1) with ESMTP id MAA02340 for ; Thu, 28 Jan 1999 12:55:23 -0800 (PST) Received: from fhcrc.org (IDENT:dnichols@pc19675 [140.107.115.26]) by snap.fhcrc.org (8.9.1/8.9.1) with ESMTP id MAA18699 for ; Thu, 28 Jan 1999 12:55:22 -0800 (PST) Sender: dnichols@snap.fhcrc.org Message-ID: <36B0CEF5.A49B6E32@fhcrc.org> Date: Thu, 28 Jan 1999 20:56:21 +0000 From: Douglas Nichols X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.0.34 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Character type name?? How to lower case it? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I have this script: SELECT a.attname, t.typname, a.attlen FROM pg_class c, pg_attribute a, pg_type t WHERE c.relname = 'regis' and a.attname in ('var1','var2',var3'); but a.attname is of type name, inwhich text(..) or lower(..) do not work with this type and I do not seem to be able to convert type name to text.... Can someone help me get around this? Thanks -- Cheers Douglas Nichols dnichols@fhcrc.org ---------------------------------------------------------------------------- Fred Hutchinson Cancer Research Center