Postgres Pro
Downloads
Home   >   mailing lists

Re: Moving from PHP to Java: A result was returned when none was expected. - Mailing list pgsql-general

From Alexander Farber
Subject Re: Moving from PHP to Java: A result was returned when none was expected.
Date
Msg-id CAADeyWhP6qgC8c8NE+wC-1sVAR9gOPs-XR2S14x9E=9PPqqj9A@mail.gmail.com
Whole thread Raw
In response to Re: Moving from PHP to Java: A result was returned when none was expected.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Moving from PHP to Java: A result was returned when none was expected.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Moving from PHP to Java: A result was returned when none was expected.  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Moving from PHP to Java: A result was returned when none was expected.  (Jan de Visser <jan@de-visser.net>)
List pgsql-general
Tree view
I only understand a quarter of what you guys are writing, 
but to me the JDBC driver throwing SQLException
"A result was returned when none was expected"
when my stored function is declared as "void" with

CREATE OR REPLACE FUNCTION words_skip_game(
        IN in_uid integer,
        IN in_gid integer)
        RETURNS void AS
$func$
BEGIN

is a strange decision. Why throw the exception, what's the benefit?

Even if PostgreSQL does not have stored functions (???),
why does not JDBC driver workaround that fact?

Regards
Alex

pgsql-general by date:

Previous
From: Ken Tanzer
Date:
Subject: Re: Converting Postgres SQL constraint logic to PHP?
Next
From: Adrian Klaver
Date:
Subject: Re: Fwd: regarding schema only migration from sqlserver to postgres with runmtk.sh