Postgres Pro
Downloads
Home   >   mailing lists

Re: Aggregate function: Different results with jdbc and psql - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Aggregate function: Different results with jdbc and psql
Date
Msg-id 12441.1223382061@sss.pgh.pa.us
Whole thread Raw
In response to Aggregate function: Different results with jdbc and psql  (Tilman Rassy <rassy@math.TU-Berlin.DE>)
List pgsql-jdbc
Tree view 
Tilman Rassy <rassy@math.TU-Berlin.DE> writes:
> I have the following problem: A certain query, i.e.,
> ...
> when I issue it in psql. When I use the same query from JDBC in Java, the
> column "grade" is SQL NULL.

It's hard to believe it's really the "same" query in both cases.  Maybe
you're using parameters in the JDBC case and they're not quite right?
Maybe the Java user has a different search_path or something?

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Guillaume Cottenceau
Date:
Subject: Re: Aggregate function: Different results with jdbc and psql
Next
From: "Wm.A.Stafford"
Date:
Subject: The plan changes when the limit gets above ~850,000