Re: Strange limit and offset behaviour....

From: Bjørn T Johansen <btj(at)havleik(dot)no>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Strange limit and offset behaviour....
Date: 2009-02-07 22:22:19
Message-ID: 20090207232219.695274e6@pennywise.havleik.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, 7 Feb 2009 22:03:37 +0000
Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> wrote:

> 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;
>
>
>

yes, they are the same... And returns the same, now when I have created an index for the dato field...

BTJ

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-02-07 22:24:09 Re: Strange limit and offset behaviour....
Previous Message Grzegorz Jaśkiewicz 2009-02-07 22:03:37 Re: Strange limit and offset behaviour....