pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedLimit Questions 2
4+ messages / 3 participants
[nested] [flat]
* Limit Questions 2
@ 1999-04-29 17:49 Mr. Poet <poet@linuxports.com>
0 siblings, 0 replies; 4+ messages in thread
From: Mr. Poet @ 1999-04-29 17:49 UTC (permalink / raw)
To: pgsql-sql
can you do a
select * from company_auth LIMIT 10-100?
--poet@linuxports.com--
ICQ: 33017215
http://www.linuxports.com
--Power to the Penguin--
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: [SQL] Limit Questions 2
@ 1999-04-29 18:37 Jackson, DeJuan <djackson@cpsgroup.com>
1999-04-30 00:06 ` Re: [SQL] Limit Questions 2 Chris Bitmead <chris.bitmead@bigfoot.com>
0 siblings, 1 reply; 4+ messages in thread
From: Jackson, DeJuan @ 1999-04-29 18:37 UTC (permalink / raw)
To: poet@linuxports.com; pgsql-sql
try: select * from company_auth LIMIT 10,90
-DEJ
> can you do a
>
> select * from company_auth LIMIT 10-100?-
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] Limit Questions 2
1999-04-29 18:37 RE: [SQL] Limit Questions 2 Jackson, DeJuan <djackson@cpsgroup.com>
@ 1999-04-30 00:06 ` Chris Bitmead <chris.bitmead@bigfoot.com>
0 siblings, 0 replies; 4+ messages in thread
From: Chris Bitmead @ 1999-04-30 00:06 UTC (permalink / raw)
To: pgsql-sql
"Jackson, DeJuan" wrote:
>
> try: select * from company_auth LIMIT 10,90
What does this syntax mean?
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: [SQL] Limit Questions 2
@ 1999-04-30 15:39 Jackson, DeJuan <djackson@cpsgroup.com>
0 siblings, 0 replies; 4+ messages in thread
From: Jackson, DeJuan @ 1999-04-30 15:39 UTC (permalink / raw)
To: Chris Bitmead <chris.bitmead@bigfoot.com>; pgsql-sql
sorry it would be:
SELECT * FROM company_auth LIMIT 90,10;
aka
SELECT * FROM company_auth LIMIT 90 OFFSET 10;
It means to give me at most 90 rows after skipping the first 10.
> > try: select * from company_auth LIMIT 10,90
>
> What does this syntax mean?
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-04-30 15:39 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-04-29 17:49 Limit Questions 2 Mr. Poet <poet@linuxports.com>
1999-04-29 18:37 RE: [SQL] Limit Questions 2 Jackson, DeJuan <djackson@cpsgroup.com>
1999-04-30 00:06 ` Chris Bitmead <chris.bitmead@bigfoot.com>
1999-04-30 15:39 RE: [SQL] Limit Questions 2 Jackson, DeJuan <djackson@cpsgroup.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox