Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    8

    Unanswered: Ho to select for example the first 10 record, the second 10 record etc

    I wanto tio select a first ten record with one select after the second 10 record ...

    is possible to do?

    thanks

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    docs???

    OFFSET LIMIT

    I you have postgres running typ in \h SELECT

    OFFSET is the starting record and LIMIT how much you want to display
    in your case it would be 10
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    Jan 2004
    Posts
    1
    Yeah, you should definitely take a look into the PostgreSQL manual. In particular it's important to ORDER BY your querys or you will get inconsistent results.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •