Re: [HACKERS] SELECT ... LIMIT (trial implementation)

On Sun, 18 Oct 1998, Tom Lane wrote:

> Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> writes:
> > What if someone wants the rows from 500 to the end. Should we allow
> > the syntax to be:
> > SELECT ... [LIMIT count] [OFFSET offset]
> > LIMIT and OFFSET are independent.
>
> I like that syntax the best, but remember we are not inventing in
> a green field here. Isn't this a feature that already exists in
> other DBMs? We should probably copy their syntax, unless it's
> truly spectacularly awful...
>
> regards, tom lane

None that I have used (VFP, M$ SQL Server) that had 'LIMIT', had 'OFFSET'.
So it would seem that the very idea of OFFSET is to break with what others
are doing.

I too like the above syntax.
Why mimic, when you can do better? Go for it!

Just my vote, have a great day
Terry Mackintosh <terry(at)terrym(dot)com> http://www.terrym.com
sysadmin/owner Please! No MIME encoded or HTML mail, unless needed.

Proudly powered by R H Linux 4.2, Apache 1.3, PHP 3, PostgreSQL 6.3
-------------------------------------------------------------------
Success Is A Choice ... book by Rick Patino, get it, read it!