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

From José Soares
Subject Re: [SQL] LIMIT
Date
Msg-id 37287E86.E15A82EB@sferacarta.com
Whole thread Raw
In response to Re: [SQL] LIMIT  (Mark Jewiss <mark@office.knowledge.com>)
List 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'




pgsql-hackers by date:

Previous
From: Peter T Mount
Date:
Subject: Re: SIGBUS in AllocSetAlloc & jdbc
Next
From: Andy Lewis
Date:
Subject: PLpgSQL Stat Problem