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 10:45:34 +1000
Message-ID: <01BE8E3F.959B0140.jbarnett@pobox.com> (raw)
On Saturday, 24 April 1999 6:45, herouth maoz [SMTP:herouth@oumail.openu.ac.il]
wrote:
> No, the question is whether Postgres's behaviour - of returning a row with
> a null field in case no rows fell into the WHERE category - is compatible
> with other databases, or indeed with the SQL standard. I don't have the
> standard in front of me at this moment. But you must understand that this
> is how PostgreSQL behaves, no matter whether your frontend is in Java,
> python, perl or C. It's not a question of JDBC.
I concede your point on that. I'm just obsessing over the ultimate result of
this quirk(?) - independence of the application.
From a practicalities point of view, if the result is not compliant with the
SQL standard, the question is whether to hide it in the abstraction layer (JDBC
driver) or fix it at the source - I guess costs and complexity of the fix will
determine that (although it is always better to fix it at the source). Of
course, hiding it in the abstraction layer means you need to do the same for
every interface (which is a headache for maintainers).
This is just speculation and musing, in any case, as I am not sure what the SQL
standard says with respect to this limit case (where a table is empty). More
research needed I suppose. :)
JonB.
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: <01BE8E3F.959B0140.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