Works a treat thank you.
One last one (I hope).
I have a SELECT PreparedStatemet which contains:-
( tried - created) >= interval ?
where tried and created are TimeStamps. In earlier releases
I could simply use setString( 1, "5 minutes");. Or do I have to
change it to ( tried - created) >= ? and then set the interval
with setTimestamp, or what?
David
On Friday 14 April 2006 19:51, Nicholas E. Wakefield wrote:
> Try limit null, that appears to return all results.
>
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of David Goodenough
> Sent: Friday, April 14, 2006 11:22 AM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] What is the number equivalient of LIMIT ALL
>
> When I try to execute a prepared statement containing LIMIT ? the
> Postgresql JDBC now requires the value to be an integer. As the
> value for LIMIT can either be a count or ALL this raises a simple
> question, what is the numeric value that means ALL?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq