Horton

Re: [SQL] LIMIT

Mark Jewiss <mark@office.knowledge.com>

View thread
From: Mark Jewiss <mark@office.knowledge.com>
To: José Soares <jose@sferacarta.com>
Cc: Chris Bitmead <chris.bitmead@bigfoot.com>, hackers <pgsql-hackers@postgresql.org>
Date: 1999-04-29T14:57:38Z
Lists: pgsql-hackers 
> 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.