Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] LIMIT - Mailing list pgsql-hackers

From Mark Jewiss
Subject Re: [SQL] LIMIT
Date
Msg-id Pine.BSF.4.05.9904291554160.20394-100000@office.knowledge.com
Whole thread Raw
In response to Re: [SQL] LIMIT  (José Soares <jose@sferacarta.com>)
List pgsql-hackers
Tree view 
> 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.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] FYI: snapshot 4/28/1999 (fwd)
Next
From: Brian P Millett
Date:
Subject: Re: [HACKERS] FYI: snapshot 4/28/1999 (fwd)