List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 31 2000 12:43pm
Subject:Re: Select clause with limit
View as plain text  
At 11:23 AM +0100 2000-01-31, Benjamin Pflugmann wrote:
>On Mon, Jan 31, 2000 at 05:11:19AM -0500, dvanhorn@stripped wrote:
>>
>>  > IIRC, LIMIT offsets start with 1, not with 1. So you were asking for
>>  > the 1 record starting with the 0th, were there is only a "1th", and
>>  > therefore you got records 0 to 0, which are none.
>>
>>  WHAT?  I'm sure there's a typo in your first assertion. :)
>
>Jup. Read is as "...start with 1, not with 0".
>
>Was just a test to see if everybody is listening. ;-)
>
>Bye,
>
>         Benjamin.


We're listening, but it's still incorrect. :-)
LIMIT offsets start with 0, not 1.

-- 
Paul DuBois, paul@stripped
Thread
transactionsCarlos Proal29 Jan
  • Re: transactionssasha30 Jan
  • Re: transactionsBenjamin Pflugmann30 Jan
Re: transactionsCarlos Proal30 Jan
  • Re: transactionsBenjamin Pflugmann30 Jan
Re: transactionsCarlos Proal31 Jan
  • Select clause with limitDave VanHorn31 Jan
    • Re: Select clause with limitBenjamin Pflugmann31 Jan
  • Re: Select clause with limitDave VanHorn31 Jan
    • Re: Select clause with limitBenjamin Pflugmann31 Jan
      • Re: Select clause with limitPaul DuBois31 Jan
  • Re: Select clause with limitDave VanHorn31 Jan
  • Re: transactionsBenjamin Pflugmann3 Feb