X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 68F73528C8 for ; Mon, 16 May 2005 15:48:03 -0300 (ADT) 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 78655-05 for ; Mon, 16 May 2005 18:47:58 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.194]) by svr1.postgresql.org (Postfix) with ESMTP id C371352833 for ; Mon, 16 May 2005 15:47:57 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 68so2378686wri for ; Mon, 16 May 2005 11:47:59 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=S9lw+nNliYajGFYUquZFeplLhy+lbuon5SuSxKAAn8cQxpcwxIWgrtYqQru1zFaohG0rAowQUqPB9ZungoHOmD2MBs/n+aUEQ/cMyhFR5uZiOrfwIs+v+3uWvvzLYRCQk3FZ/QLWk1QeWevbtRthEktb3ez+YoqkMVf1ibgjIYo= Received: by 10.54.76.2 with SMTP id y2mr3846342wra; Mon, 16 May 2005 11:47:59 -0700 (PDT) Received: by 10.54.40.39 with HTTP; Mon, 16 May 2005 11:47:59 -0700 (PDT) Message-ID: Date: Mon, 16 May 2005 11:47:59 -0700 From: David B Reply-To: David B To: pgsql-sql@postgresql.org Subject: ORDER BY handling mixed integer and varchar values Mime-Version: 1.0 Content-Type: text/plain; charset=WINDOWS-1252 Content-Transfer-Encoding: base64 Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.831 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FROM_ENDS_IN_NUMS, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200505/111 X-Sequence-Number: 21424 SGkgQWxsLApJIGhhdmUgYSB0YWJlCgpQcm9kdWN0X2Rlc2MgIHZhcmNoYXIoMTAwKQpQcm9kdWN0 X3ByaWNlICBpbnRlZ2VyClByb2R1Y3RfY2F0ICAgIHZhcmNoYXIoMTAwKQoKVGhlIHByb2JsZW2F CgpXZSBoYXZlIGNhdGVnb3JpZXMgc3VjaCBhczoKCkVsZWN0cm9uaWNzCldoaXRlIEdvb2RzCjEK Mgo1CjE1CjI1CmV0YwoKSSBoYXZlIGEgcXVlcnkKClNlbGVjdCBwcm9kdWN0X2Rlc2MsIHByb2R1 Y3RfcHJpY2UsIHByb2R1Y3RfY2F0Ck9yZGVyIGJ5IHByb2R1Y3RfY2F0LCBwcm9kdWN0X3ByaWNl CgpBbmQgb2YgY291cnNlIEkgZ2V0IHN0dWZmIG9yZGVyZWQgYXMgSSB3YW50IGl0LgpCVVSFIHdp dGggbWFueSBwcm9kdWN0IGNhdGVnb3JpZXMgYmVpbmcgbnVtZXJpYyBiYXNlZCB0aGV5IGNvbWUg b3V0IGluCndyb25nIG9yZGVyICAgJzEwIGNvbWVzIGJlZm9yZSAyIiBldGMuCgpTbyBJIHRyaWVk ClNlbGVjdCBwcm9kdWN0X2Rlc2MsIHByb2R1Y3RfcHJpY2UsIHByb2R1Y3RfY2F0Ck9yZGVyIGJ5 IGNhc3QocHJvZHVjdF9jYXQgYXMgaW50ZWdlciksIHByb2R1Y3RfcHJpY2UKCkFuZCB0aGF0IHdv cmtlZCBmb3IgdGhlIG51bWJlcmljIGJhc2VkIGNhdGVnb3JpZXMuCgpJIGRvbid0IGtub3cgb2Yg YSBxdWVyeSB3aWxsIGJlIGFjcm9zcyBhbHBoYSBvciBudW1lcmljIGNhdGVnb3JpZXMuCgpJcyB0 aGVyZSBhbnkgZWxlZ2VudCBxdWVyeSB5b3UgZm9sa3MgY2FuIHRoaW5rIG9mIHRoYXQgY29tYmlu ZXMgdGhlCnR3byBzbyBJIGNhbiBvbmUgcXVlcnkgdGhhdCBoYXMgYWxwaGEgc29ydGluZyBvbiBh bHBoYSBjYXRlZ29yaWVzIGFuZApudW1lcmljIHNvcnRpbmcgb24gbnVtZXJpYyB2YWx1ZXMgdGhh dCBhcmUgaW4gdGhlIHNhbWUgY29sdW1uPz8KClRpYS4K