Have you tried using the LIMIT clause?
select porducts from sales limit 10;
http://www.postgresql.org/docs/8.1/interactive/queries-limit.html
On Thu, 11 May 2006, Karen Hill wrote:
It seems PostgreSQL doesn't have a TOP Predicate. Why is that? Here
is an example:
SELECT TOP 10 products from sales;
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
