Re: [SQL] LIMIT

From: Mark Jewiss <mark(at)office(dot)knowledge(dot)com>
To: Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] LIMIT
Date: 1999-04-29 09:24:46
Message-ID: Pine.BSF.4.05.9904291023430.4008-100000@office.knowledge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

> > Could someone give me an example of a select * with LIMIT
> > used by 6.5?
>
> SELECT * FROM foobar LIMIT 100

Or you could use ROWCOUNT...

set rowcount = 10
select * from table

Regards,

Mark.
--
Mark Jewiss
Knowledge Matters Limited

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Massimo Dal Zotto 1999-04-29 09:28:22 Re: [HACKERS] How do I get the backend server into gdb?
Previous Message Zeugswetter Andreas IZ5 1999-04-29 08:59:11 AW: [HACKERS] Pg takes at least 2 hours to retrieve 7650 rows

Browse pgsql-sql by date

  From Date Subject
Next Message Herouth Maoz 1999-04-29 10:04:54 Re: [SQL] Finding the "most recent" rows
Previous Message Dirk Lutzebaeck 1999-04-29 08:06:18 Re: [SQL] LIMIT