Horton

Re: [SQL] LIMIT

Jose Soares <jose@sferacarta.com>

View thread
From: José Soares <jose@sferacarta.com>
To: Mark Jewiss <mark@office.knowledge.com>
Cc: Chris Bitmead <chris.bitmead@bigfoot.com>, hackers <pgsql-hackers@postgresql.org>
Date: 1999-04-29T15:45:10Z
Lists: pgsql-hackers 
hygea=> set rowcount 10;
ERROR:  parser: parse error at or near "10"

Which version of Postgres are you using?


Mark Jewiss ha scritto:

> > 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.

--
______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'