Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id AD7509FB8BE for ; Tue, 24 Apr 2007 11:46:15 -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 43166-06 for ; Tue, 24 Apr 2007 11:46:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx2.ipf.is (scania.ipf.is [85.197.192.147]) by postgresql.org (Postfix) with ESMTP id 1D1509FB892 for ; Tue, 24 Apr 2007 11:46:06 -0300 (ADT) Received: (qmail 8008 invoked by uid 1010); 24 Apr 2007 14:44:20 +0000 Received: from 88.149.106.19 by scania (envelope-from , uid 1008) with qmail-scanner-1.25-st-qms (clamdscan: 0.88/1235. spamassassin: 3.1.1. perlscan: 1.25-st-qms. Clear:RC:1(88.149.106.19):SA:0(-2.1/4.5):. Processed in 0.539116 secs); 24 Apr 2007 14:44:20 -0000 X-Antivirus-IPF-Mail-From: gnari@hive.is via scania X-Antivirus-IPF: 1.25-st-qms (Clear:RC:1(88.149.106.19):SA:0(-2.1/4.5):. Processed in 0.539116 secs Process 8001) Received: from dsl-149-106-19.hive.is (HELO ?192.168.1.33?) (88.149.106.19) by mx2.ipf.is with SMTP; 24 Apr 2007 14:44:19 +0000 Subject: Re: hi From: Ragnar To: "Penchalaiah P." Cc: pgsql-sql@postgresql.org In-Reply-To: References: Content-Type: text/plain; charset=ISO-8859-1 Date: Tue, 24 Apr 2007 15:05:29 +0000 Message-Id: <1177427129.15187.44.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/232 X-Sequence-Number: 28232 On ūri, 2007-04-24 at 17:39 +0530, Penchalaiah P. wrote: > Hi > > I have the data like this in temp table > > SQL> Select sno, value from temp; you seem to be assuming a specific order for this. gnari