Re: What is the number equivalient of LIMIT ALL

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
Thread:
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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Clemens A Mensik 2006-04-15 06:42:38 test-mail
Previous Message David Goodenough 2006-04-14 18:21:51 What is the number equivalient of LIMIT ALL