Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C86F19FB6E0 for ; Wed, 28 Feb 2007 09:18:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 70782-06 for ; Wed, 28 Feb 2007 09:18:34 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 6A6729FA36A for ; Wed, 28 Feb 2007 09:18:50 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1HMOw9-0003Jz-6X for pgsql-sql@postgresql.org; Wed, 28 Feb 2007 08:33:41 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 9A7004051; Wed, 28 Feb 2007 08:18:43 -0500 (EST) Date: Wed, 28 Feb 2007 08:18:43 -0500 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: Case with Char(1) Message-ID: <20070228131843.GA6648@phlogiston.dyndns.org> References: <55c095e90702280502x3673fe6g67e7cb5de714356f@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <55c095e90702280502x3673fe6g67e7cb5de714356f@mail.gmail.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/292 X-Sequence-Number: 27626 On Wed, Feb 28, 2007 at 10:02:38AM -0300, Ezequias Rodrigues da Rocha wrote: > Hi list, > > it is possible to use case with character (1) ? > > I am having problems to formate the SQL statement. Your example looked like it worked. A -- Andrew Sullivan | ajs@crankycanuck.ca Users never remark, "Wow, this software may be buggy and hard to use, but at least there is a lot of code underneath." --Damien Katz