From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | andreas(dot)zeugswetter(at)telecom(dot)at (Andreas Zeugswetter) |
Cc: | hackers(at)postgreSQL(dot)org |
Subject: | Re: AW: [HACKERS] SELECT ... LIMIT (trial implementation) |
Date: | 1998-10-19 15:27:30 |
Message-ID: | 199810191527.LAA09854@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
> > 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...
>
> Informix uses the following syntax, but does not have the offset feature:
>
> select first 100 * from table ....
I definitely don't like that syntax.
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-10-19 15:29:56 | Re: [HACKERS] HAVING bug |
Previous Message | Thomas G. Lockhart | 1998-10-19 15:16:10 | [Fwd: DocBook stylesheets 1.19 released] |