On 09.06.2005 03:13 Alain wrote:
>
>
> Tom Lane escreveu:
>
>> Thomas Kellerer <spam_eater(at)gmx(dot)net> writes:
>>
>>> Is there anything I can do, to convince PG to return the first row
>>> more quickly?
>
>
> Are you now looking for the LIMIT ?
>
> SELECT * FROM table LIMIT 1;
>
> and when when you wnat the rest of it:
>
> SELECT * FROM table OFFSET 1;
>
No I want the whole result.
Thomas