Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43065=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Xr6Te-0004J9-Gv
 for pgsql-admin@arkaria.postgresql.org; Wed, 19 Nov 2014 14:43:26 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43065=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Xr6Te-0000Nl-1T
 for pgsql-admin@arkaria.postgresql.org; Wed, 19 Nov 2014 14:43:26 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <scott_ribe@elevated-dev.com>)
 id 1Xr6Td-0000Ne-Ah
 for pgsql-admin@postgresql.org; Wed, 19 Nov 2014 14:43:25 +0000
Received: from mailout.easymail.ca ([64.68.201.169])
 by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <scott_ribe@elevated-dev.com>)
 id 1Xr6TZ-0000DV-Fj
 for pgsql-admin@postgresql.org; Wed, 19 Nov 2014 14:43:24 +0000
Received: from localhost (localhost [127.0.0.1])
 by mailout.easymail.ca (Postfix) with ESMTP id C7665E195;
 Wed, 19 Nov 2014 09:43:18 -0500 (EST)
X-Virus-Scanned: Debian amavisd-new at mailout.easymail.ca
X-Spam-Flag: NO
X-Spam-Score: -4.368
X-Spam-Level: 
X-Spam-Status: No, score=-4.368 required=5 tests=[ALL_TRUSTED=-1.8, AWL=0.031,
 BAYES_00=-2.599]
Received: from mailout.easymail.ca ([127.0.0.1])
 by localhost (easymail-mailout.easydns.vpn [127.0.0.1]) (amavisd-new,
 port 10024)
 with ESMTP id 7cbBYplnFJAM; Wed, 19 Nov 2014 09:43:18 -0500 (EST)
Received: from [192.168.2.16] (unknown [8.39.228.5])
 (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
 (No client certificate requested)
 by mailout.easymail.ca (Postfix) with ESMTPSA id C66DEE16E;
 Wed, 19 Nov 2014 09:43:17 -0500 (EST)
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 8.0 \(1990.1\))
Subject: Re: order by query wrong result
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: 
 <CAJghg4+r4WRsGM_K0G6swXaKCMdRMN-QXu7hsM6aHx0112q-5A@mail.gmail.com>
Date: Wed, 19 Nov 2014 07:43:16 -0700
Cc: "ktm@rice.edu" <ktm@rice.edu>, John Scalia <jayknowsunix@gmail.com>,
 Silvio Brandani <silvio.brandani@tech.sdb.it>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <348EDCED-E812-4763-9043-2B534DB11C94@elevated-dev.com>
References: <546CA188.705@tech.sdb.it>
 <CB75D42A-9FCD-46D7-AF05-F005BF820385@gmail.com>
 <98519DF5-9539-434F-916B-BFF33F24A6A5@elevated-dev.com>
 <20141119142700.GI10679@aart.rice.edu>
 <4F51E832-861A-4E83-8445-E9F32B079254@elevated-dev.com>
 <CAJghg4+r4WRsGM_K0G6swXaKCMdRMN-QXu7hsM6aHx0112q-5A@mail.gmail.com>
To: Matheus de Oliveira <matioli.matheus@gmail.com>
X-Mailer: Apple Mail (2.1990.1)
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On Nov 19, 2014, at 7:39 AM, Matheus de Oliveira <matioli.matheus@gmail.com=
> wrote:
>=20
> If you ignore dots, spaces, and dashs, you have that result.

No, you do not. You also have to ignore the "S." of "S.L.", and that's what=
 threw me off the first time.

--=20
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice






--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin