Re: Strange limit and offset behaviour.... - Mailing list pgsql-general

On Sat, Feb 7, 2009 at 9:57 PM, Bjørn T Johansen <btj@havleik.no> wrote:
>> > SELECT * from table order by dato asc

is the field 'dato' the same in both cases ? if so - you're goood
just compare:

select dato from table order by dato asc limit 10;
with
select dato from table order by dato asc limit 10 offset 0;



--
GJ