From: Jon Barnett <jbarnett@pobox.com>
To: 'Herouth Maoz' <herouth@oumail.openu.ac.il>
To: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>
Subject: RE: [INTERFACES] JDBC next() method
Date: Sat, 24 Apr 1999 01:26:12 +1000
Message-ID: <01BE8DF1.71754C60.jbarnett@pobox.com> (raw)
On Tuesday, 20 April 1999 1:35, Herouth Maoz [SMTP:herouth@oumail.openu.ac.il]
wrote:
> At 15:57 +0300 on 14/04/1999, Jon Barnett wrote:
>
>
> > I had expected that an empty result set would be
> > returned if the history table is empty (0 rows returned for the select),
> > and
> > queryResult.next() would be false. Is this an incorrect interpretation
> >on my
> > part?
>
> It is. In PostgreSQL, when an aggregate function is used, it always returns
> one row containing one field. If it had no values that matched the query,
> that one field is NULL.
The question is less one of "what is required to correctly interpret the result
from the postgresql jdbc driver" and more a case of determining whether this
result conforms to the jdbc api definitions. To re-phrase this; if I employed
a different JDBC driver, would I obtain the same result? For after all, the
goal of the JDBC layer is to provide a consistent interface, independent of the
database to which you are connecting, particularly when you can late bind the
driver (specify the driver you want to use at run-time).
Best regards,
Jon.
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jbarnett@pobox.com, herouth@oumail.openu.ac.il, pgsql-interfaces@hub.org
Subject: RE: [INTERFACES] JDBC next() method
In-Reply-To: <01BE8DF1.71754C60.jbarnett@pobox.com>
* 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