Re: [SQL] LIMIT

From: Mark Jewiss <mark(at)office(dot)knowledge(dot)com>
To: José Soares <jose(at)sferacarta(dot)com>
Cc: Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com>, hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [SQL] LIMIT
Date: 1999-04-29 14:57:38
Message-ID: Pine.BSF.4.05.9904291554160.20394-100000@office.knowledge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

> I don't know nothing about ROWCOUNT.
> SET ROWCOUNT doesn't work for me.
> hygea=> set rowcount = 10;

Sorry, this is my faul. Correct SQL syntax is

set rowcount 10

Cheers,

Mark.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Brian P Millett 1999-04-29 14:59:05 Re: [HACKERS] FYI: snapshot 4/28/1999 (fwd)
Previous Message Tom Lane 1999-04-29 14:19:28 Re: [HACKERS] FYI: snapshot 4/28/1999 (fwd)

Browse pgsql-sql by date

  From Date Subject
Next Message Herouth Maoz 1999-04-29 15:03:54 Re: [SQL] Finding the "most recent" rows
Previous Message Chris Bitmead 1999-04-29 14:28:22 Re: [SQL] Finding the "most recent" rows