Home > mailing lists

limit 0,10 within SELECT ..... FROM ...... - Mailing list pgsql-general

From	Paul Ottar Tornes
Subject	limit 0,10 within SELECT ..... FROM ......
Date	November 1, 2002 12:13:26
Msg-id	01fe01c281b1$cdd8b0c0$0400000a@critical Whole thread Raw
Responses	Re: limit 0,10 within SELECT ..... FROM ...... limit 0,10 within SELECT ..... FROM ......
List	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

From: Doug McNaught
Date: 01 November 2002, 11:50:54
Subject: Re: 7.2.3: tuple is too big (max 8136)

From: Darren Ferguson
Date: 01 November 2002, 12:19:43
Subject: Re: limit 0,10 within SELECT ..... FROM ......