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

Поиск

Список

Период

Сортировка

От	Paul Ottar Tornes
Тема	limit 0,10 within SELECT ..... FROM ......
Дата	1 ноября 2002 г. 09:13:26
Msg-id	01fe01c281b1$cdd8b0c0$0400000a@critical обсуждение исходный текст
Ответы	Re: limit 0,10 within SELECT ..... FROM ...... limit 0,10 within SELECT ..... FROM ......
Список	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

В списке pgsql-general по дате отправления: