Re: ASK about SQL - Mailing list pgsql-sql

Do you mean you want it to order it in the same order as you've listed them
in the IN condition?


-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of ali nas
Sent: Thursday, 31 May 2007 17:57
To: pgsql-sql@postgresql.org
Subject: [SQL] ASK about SQL

Dear all,
   HELP me
PLZ.........................................................................
...................

I'm used this SQL command :       "" SELECT ean FROM icitem WHERE ean in
(4902715720005,4909411012151,4909411010164,4902715688718,4902715731605,49094
11008864,4909411010188,4909411010126,4909411010140,490941101
2052,4902715720104,4909411010089,4909411010201,0,0) ; """";


The FILE content :                                   but the result is :
                      ean 
---------------
4902715720005                                         4902715720005
4909411012151                                         4902715720104
4909411010164                                         4902715688718
4902715688718                                         4902715731605
4902715731605                                         4909411008864
4909411008864                                         4909411010089
4909411010188                                         4909411010126
4909411010126                                         4909411010140
4909411010140                                         4909411010164
4909411012052                                         4909411010188
4902715720104                                         4909411010201
4909411010089                                         4909411012052
4909411010201                                         4909411012151


that is different RESULT with the input !!! what must I do if i dont want
POSTGRES not ORDER my SELECT data ????

THX's


________________________________________________________
Kunjungi halaman depan Yahoo! Indonesia yang baru!
http://id.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to      choose an index scan if your joining column's
datatypesdo not      match 


*******************Confidentiality and Privilege Notice*******************

The material contained in this message is privileged and confidential to
the addressee.  If you are not the addressee indicated in this message or
responsible for delivery of the message to such person, you may not copy
or deliver this message to anyone, and you should destroy it and kindly
notify the sender by reply email.

Information in this message that does not relate to the official business
of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta.
Weatherbeeta, its employees, contractors or associates shall not be liable
for direct, indirect or consequential loss arising from transmission of this
message or any attachments