Re: What is the number equivalient of LIMIT ALL

Lists: pgsql-jdbc
From: "Nicholas E(dot) Wakefield" <nwakefield(at)KineticNetworks(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: What is the number equivalient of LIMIT ALL
Date: 2006-04-14 18:51:15
Message-ID: 2F2A7EB72EBAF24582513E72ACCBCAAE0A286B@kniexch01.KineticNetworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-jdbc

Try limit null, that appears to return all results.

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of David Goodenough
Sent: Friday, April 14, 2006 11:22 AM
To: pgsql-jdbc(at)postgresql(dot)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

From: David Goodenough <david(dot)goodenough(at)btconnect(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: What is the number equivalient of LIMIT ALL
Date: 2006-04-16 20:58:23
Message-ID: 200604162158.24895.david.goodenough@btconnect.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-jdbc

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(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of David Goodenough
> Sent: Friday, April 14, 2006 11:22 AM
> To: pgsql-jdbc(at)postgresql(dot)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