Re: [SQL] LIMIT

Mark Jewiss ha scritto:

> > > Could someone give me an example of a select * with LIMIT
> > > used by 6.5?
> >
> > SELECT * FROM foobar LIMIT 100
>
> Or you could use ROWCOUNT...
>
> set rowcount = 10
> select * from table
>
> Regards,
>
> Mark.
> --
> Mark Jewiss
> Knowledge Matters
> Limited--------------------------------------------------------------

I don't know nothing about ROWCOUNT.
SET ROWCOUNT doesn't work for me.
hygea=> set rowcount = 10;
ERROR:  parser: parse error at or near "10"

PostgreSQL still accepts SET QUERY_LIMIT but it doesn't work...

hygea=> set query_limit to '1';
SET VARIABLE
hygea=> select * from contatori;
tipologia|tabella        |contatore|contatorebis
---------+---------------+---------+------------
SOTTO    |Modena         |        1|           2
SOPRA    |prestazioni    |       20|
(2 rows)
--------------------------------------------------------------
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
-----------------------------------------------------------------------------------

José