Re: Strange limit and offset behaviour....

On Sat, Feb 7, 2009 at 9:57 PM, Bjørn T Johansen <btj(at)havleik(dot)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