Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id CE99E6323CD for ; Thu, 24 Jun 2010 14:26:46 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 25574-10 for ; Thu, 24 Jun 2010 17:26:39 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pw0-f46.google.com (mail-pw0-f46.google.com [209.85.160.46]) by mail.postgresql.org (Postfix) with ESMTP id 9D5396322D5 for ; Thu, 24 Jun 2010 14:26:39 -0300 (ADT) Received: by pwj8 with SMTP id 8so1947685pwj.19 for ; Thu, 24 Jun 2010 10:26:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=nldNrYTr0NtZTG+iWIhWGw2SaRkeBRG6/oJh7gjrSmI=; b=o59MStYzmOnTm1QGeqxvrebaTSQ2DMcxDUA01vMEqTYO83+rdZ6ATfjHnyG7lOLBFL C58Sa4Md5ByKmt5a5aGEBwBr3lIhWIjzqfVuFQZubGln9Qy0e734sI7vOXusRk09HwQe ZJCG+6zt6LAKQ95qzRexpElLaM66CE2EjqDYM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=Nv0KFahj5SuH5ELUjMr2tcU41F58IV0xyC9z9b8xOAgLp+TKae0NaMKD+c53iSzfNG 6DkF0YR9tH+CjrFrYT2fo9eYH/GCZjYxqe/cEfRByYSyEtKPUlb0xc0zHOUmkV10kF9f jxhPWC8D/rbBZw+iJZufVm6DrmaNaeu5QXzt8= MIME-Version: 1.0 Received: by 10.142.4.1 with SMTP id 1mr9544046wfd.50.1277400397992; Thu, 24 Jun 2010 10:26:37 -0700 (PDT) Received: by 10.231.167.10 with HTTP; Thu, 24 Jun 2010 10:26:37 -0700 (PDT) In-Reply-To: <4C212BD8.5040102@fmed.uba.ar> References: <4C212BD8.5040102@fmed.uba.ar> Date: Thu, 24 Jun 2010 13:26:37 -0400 Message-ID: Subject: Re: ORDER BY is case insensitive From: Bryan White To: Gerardo Herzig Cc: pgsql-sql@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.5 tagged_above=-5 required=5 tests=BAYES_05=-0.5, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201006/78 X-Sequence-Number: 34269 > regression=# SELECT * from test order by ascii(data); That is what I was looking for. Thanks to all. -- Bryan White