Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0ED379FB881 for ; Thu, 31 May 2007 04:56:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 33049-03 for ; Thu, 31 May 2007 04:56:49 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web38207.mail.mud.yahoo.com (web38207.mail.mud.yahoo.com [209.191.124.150]) by postgresql.org (Postfix) with SMTP id 551ED9FB712 for ; Thu, 31 May 2007 04:56:49 -0300 (ADT) Received: (qmail 82754 invoked by uid 60001); 31 May 2007 07:56:47 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=al9i+zwiBiEi0r0613IjPhtjJV3X/bHrnEvLvJA2jQXEKJG74tt/RbXsJd/sUmEICsXhBR7ZtxdbBmOVdqoqdyLngxZDJ5UcsGt7cbSNocmU2LuGs6tsthKtbZWIie9v6bUtKzIAnNnIUvG9VGFB0OGPIsmHu7JLasy4oteeFUg=; X-YMail-OSG: 0PT5pecVM1l8LI8_EJO70fL4IqZVDSHm6RdVU778Ico2QNNU9U2uiVMB5o10Yx42qQ-- Received: from [209.191.119.123] by web38207.mail.mud.yahoo.com via HTTP; Thu, 31 May 2007 00:56:47 PDT X-Mailer: YahooMailRC/651.23.1 YahooMailWebService/0.7.41.14 Date: Thu, 31 May 2007 00:56:47 -0700 (PDT) From: ali nas Subject: ASK about SQL To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=ascii Message-ID: <757228.82156.qm@web38207.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.64 tagged_above=0 required=5 tests=AWL=1.007, BAYES_50=0.001, FROM_HAS_ULINE_NUMS=0.291, WEIRD_QUOTING=1.341 X-Spam-Level: ** X-Archive-Number: 200705/205 X-Sequence-Number: 28485 Dear all, HELP me PLZ............................................................................................ I'm used this SQL command : "" SELECT ean FROM icitem WHERE ean in (4902715720005,4909411012151,4909411010164,4902715688718,4902715731605,4909411008864,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/