limit - Mailing list pgsql-general

From Paul Ottar Tornes
Subject limit
Date
Msg-id 00b601c28136$bd878eb0$0400000a@critical
Whole thread Raw
Responses Re: limit  (Jens-Christian Skibakk <jens@cultus.no>)
List pgsql-general
How come
    $query = "SELECT id, tittel, dato, kilde, referat FROM nyheter order by id desc limit 0,10";
Does not display any posts in my news script, but
    $query = "SELECT id, tittel, dato, kilde, referat FROM nyheter order by id desc limit 10";
Shows the last 10.?
 
And:
 
How come
    $query = "SELECT id, tittel, dato, kilde, referat FROM nyheter order by id desc limit 10,20";
Displays posts 5 to 14, and not 10 to 20?!
 
Regards
 
Paul Ottar Tornes

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: my.cnf to postgresql.conf Conversion
Next
From: Neil Conway
Date:
Subject: Re: my.cnf to postgresql.conf Conversion