pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Limit 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