Re: To Postgres Devs : Wouldn't changing the select limit

> But according to the list in the PostgreSQL docs OFFSET is not a
> reserved word. Is it one of the 'likely to become reserved' words?
>
>
> > IMHO "LIMIT n OFFSET n" is far more readable than "LIMIT m,n" anyway.
> > (Quick: which number is first in the comma version?  By what reasoning
> > could you deduce that if you'd forgotten?)  So I think we should
> > deprecate and eventually eliminate the comma version, if we're not
> > going to conform to the de facto standard for it.
>
>
> I agree that LIMIT n OFFSET n is by far the most readable format, and is
> therefore the desirable format. But I am not sure about deprecating and
> eliminating the other syntax. Above all it should be avoided that it is
> now deprecated but is included in the next SQL standard and has to be
> added again.

I am confused.  While LIMIT and OFFSET may are potential SQL standard
reserved words, I don't see how LIMIT #,# would ever be a standard
specification.  Do you see this somewhere I am missing.  Again, LIMIT
#,# is the only syntax we are removing.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026