Received: from rakete.joerdens.de (rakete.joerdens.de [62.104.116.200]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f089LnB86722; Mon, 8 Jan 2001 04:21:50 -0500 (EST) (envelope-from frank@joerdens.de) Received: from limedes.archi-me-des.de (pD90024EB.dip.t-dialin.net [217.0.36.235]) by rakete.joerdens.de (8.9.3/8.9.3) with ESMTP id KAA05693; Mon, 8 Jan 2001 10:45:05 +0100 Received: from joerdens.de (tricky.archi-me-des.de [192.168.100.1]) by limedes.archi-me-des.de (8.9.3/8.9.3) with ESMTP id KAA03084; Mon, 8 Jan 2001 10:05:21 +0100 Message-ID: <3A5986B5.A71BC693@joerdens.de> Date: Mon, 08 Jan 2001 10:21:57 +0100 From: Frank Joerdens X-Mailer: Mozilla 4.72 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: Adam Haberlach CC: pgsql-php@postgresql.org, pgsql-general@postgresql.org Subject: Re: PHP and PostgreSQL References: <631076786.20010105231729@sir-mag.com> <20010105220727.B4224@newsnipple.com> <3A5743EB.CFE29713@joerdens.de> <20010107194703.C16787@newsnipple.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/288 X-Sequence-Number: 2466 Adam Haberlach wrote: [ . . . ] > Once again, this is probably all due to a difference between MySQL and Postgres. > Judging by the MySQL code, there is a provision for the client-side libraries to > pass tuples on to the application in the order they are sorted without necessarily > retrieving them all to the client. AFAIK, Postgres does not do this unless you > specifically use cursors to pull down a window of data at a time (this is correct > behavior IMHO, your feelings may vary). Oops, this means that I have been coding on a false assumption for quite a while now. I guess I'll be changing quite a few while loops into for loops this week. But it's good to have a conclusive verdict on the issue. I'd been feeling somewhat uneasy about it all allong, what with not knowing exactly what the mechanism was . . . thanks for making this clear! [ . . . ] > (and judging by the number of times I've mentioned PHP and MySQL in this > post, it is time for this thread to go elsewhere. I've cross-posted to php-pgsql where I think it belongs, actually. Regards, Frank