Re: ASK about 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(at)postgresql(dot)org [mailto:pgsql-sql-owner(at)postgresql(dot)org]
On Behalf Of ali nas
Sent: Thursday, 31 May 2007 17:57
To: pgsql-sql(at)postgresql(dot)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 datatypes do 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