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 F16003A4949 for ; Wed, 1 Dec 2004 06:15:09 +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 85688-09 for ; Wed, 1 Dec 2004 06:14:50 +0000 (GMT) Received: from web14928.mail.yahoo.com (web14928.mail.yahoo.com [216.136.225.87]) by svr1.postgresql.org (Postfix) with SMTP id 1666E3A5473 for ; Wed, 1 Dec 2004 06:14:50 +0000 (GMT) Received: (qmail 42900 invoked by uid 60001); 1 Dec 2004 06:14:49 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=Y5PKGKa9aHoGmT9QmjqgwxhYq4p7XWxT4GcsWZZKLT9UhzjCvy93ndYcu1QM9jGVJPOVDTMNUtZJ2VR7cDOqJhG2+UknyafZqj7pDZXOoYapd+3f/VhngJ6kHT3tE+NZD/xiphQOXgga+96v/s3PhsweD4M3ga/2ZMBSMkvf3hM= ; Message-ID: <20041201061449.42895.qmail@web14928.mail.yahoo.com> Received: from [203.101.60.142] by web14928.mail.yahoo.com via HTTP; Tue, 30 Nov 2004 22:14:49 PST Date: Tue, 30 Nov 2004 22:14:49 -0800 (PST) From: Simon Moses Subject: order by problem To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.177 tagged_above=0 required=5 tests=DEAR_SOMETHING, DNS_FROM_RFC_ABUSE X-Spam-Level: * X-Archive-Number: 200412/12 X-Sequence-Number: 19632 dear sir, when i run a query with order by customer_name i am getting the following result(ex.). AA A B AC i want it to be A B AA AB how to achieve this. thanks in advance. -Simon Moses. ===== ************************** Visit My Home Page http://www.geocities.com/ks_moses updated: 28 Sep 2004. Simon Moses ************************** __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail