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'