Re: limit-offset different result sets with same query

From: Emanuel Calvo Franco <postgres(dot)arg(at)gmail(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Re: limit-offset different result sets with same query
Date: 2009-05-09 15:35:56
Message-ID: f205bb120905090835q54f67755jaea1dfbe2e8754d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/5/8 David Fetter <david(at)fetter(dot)org>:
> On Fri, May 08, 2009 at 06:40:33PM -0300, Emanuel Calvo Franco wrote:
>>
>> I test it in the first time :)
>>
>> With the 'order by' it works well, but in 'theory'
>
> The theory under which you should operate is that the underlying
> implementation only gives you the orderings you ask for. This way,
> when other beneficial implementation changes happen, they will not
> surprise you. :)

Yeap. now it have more sense.
Is a question of performance and to take notice of that.

Cool.
Thanks to all!,

--
Emanuel Calvo Franco
Sumate al ARPUG !
( www.arpug.com.ar)
ArPUG / AOSUG Member

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2009-05-09 17:24:20 Re: limit-offset different result sets with same query
Previous Message Wojtek 2009-05-09 13:30:51 Re: keeping track of function execution