limit 0,10 within SELECT ..... FROM ......

From: "Paul Ottar Tornes" <critical(at)tiscali(dot)no>
To: <pgsql-general(at)postgresql(dot)org>
Subject: limit 0,10 within SELECT ..... FROM ......
Date: 2002-11-01 14:20:17
Message-ID: 01fe01c281b1$cdd8b0c0$0400000a@critical
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I run PostgreSQL and have some questions:

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lee Kindness 2002-11-01 14:21:06 limit 0,10 within SELECT ..... FROM ......
Previous Message Darren Ferguson 2002-11-01 14:17:48 Re: limit 0,10 within SELECT ..... FROM ......