X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D9AA5560EE for ; Thu, 24 Feb 2005 21:53:43 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83634-05 for ; Thu, 24 Feb 2005 21:53:34 +0000 (GMT) Received: from vms048pub.verizon.net (vms048pub.verizon.net [206.46.252.48]) by svr1.postgresql.org (Postfix) with ESMTP id 6970956095 for ; Thu, 24 Feb 2005 21:53:33 +0000 (GMT) Received: from jfradkin ([66.15.127.235]) by vms048.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0ICF00GKORHMZ321@vms048.mailsrvcs.net> for pgsql-admin@postgresql.org; Thu, 24 Feb 2005 15:53:46 -0600 (CST) Date: Thu, 24 Feb 2005 16:57:44 -0500 From: "Joel Fradkin" Subject: Re: lowercase function In-reply-to: <1109279198.30529.194.camel@state.g2switchworks.com> To: "'Scott Marlowe'" , "'Zouari Fourat'" Cc: Message-id: <007301c51abb$df3c3a80$797ba8c0@jfradkin> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.15 tagged_above=0 required=5 tests=AWL, MSGID_DOLLARS X-Spam-Level: *** X-Archive-Number: 200502/293 X-Sequence-Number: 16461 Did you try select lower(columnname) from tbl ? ex: select lower(clientnum) from tblcase where clientnum = 'WAZ' Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message, including attachments. -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Scott Marlowe Sent: Thursday, February 24, 2005 4:07 PM To: Zouari Fourat Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] lowercase function lower() On Thu, 2005-02-24 at 14:57, Zouari Fourat wrote: > Hello, > Am looking for a 'tolowercase' function that returns lowercase string > that can be used like this : > > SELECT lowercase(column) FROM table; > > anyone can help me ? > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq