From: Frank Joerdens <frank@joerdens.de>
To: Adam Haberlach <adam@newsnipple.com>
Cc: pgsql-php@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: PHP and PostgreSQL
Date: Mon, 08 Jan 2001 10:21:57 +0100
Message-ID: <3A5986B5.A71BC693@joerdens.de> (raw)
References: <631076786.20010105231729@sir-mag.com>
<20010105220727.B4224@newsnipple.com>
<3A5743EB.CFE29713@joerdens.de>
<20010107194703.C16787@newsnipple.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: frank@joerdens.de, adam@newsnipple.com, pgsql-general@postgresql.org
Subject: Re: PHP and PostgreSQL
In-Reply-To: <3A5986B5.A71BC693@joerdens.de>
References: <631076786.20010105231729@sir-mag.com> <20010105220727.B4224@newsnipple.com> <3A5743EB.CFE29713@joerdens.de> <20010107194703.C16787@newsnipple.com> <3A5986B5.A71BC693@joerdens.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox