Thread: What is the number equivalient of LIMIT ALL

What is the number equivalient of LIMIT ALL

From
David Goodenough
Date:
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?

Re: What is the number equivalient of LIMIT ALL

From
"Nicholas E. Wakefield"
Date:
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

Re: What is the number equivalient of LIMIT ALL

From
David Goodenough
Date:
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