Horton

Thread

  1. LIMIT

    Poet/Joshua Drake <poet@linuxports.com> — 1999-04-29T05:22:58Z

    Could someone give me an example of a select * with LIMIT used 
by 6.5?
  --poet@linuxports.com--
      ICQ: 33017215
 http://www.linuxports.com
  --Power to the Penguin--

  2. Re: [SQL] LIMIT

    Chris Bitmead <chris.bitmead@bigfoot.com> — 1999-04-29T05:47:35Z

    "Mr. Poet" wrote:
> 
> Could someone give me an example of a select * with LIMIT 
> used by 6.5?

SELECT * FROM foobar LIMIT 100

  3. Re: [SQL] LIMIT

    Dirk Lutzebäck <lutzeb@aeccom.com> — 1999-04-29T08:06:18Z

    Besides, I have problems with SELECT LIMIT on unions in
6.5beta1. Anyone else?

Dirk

  4. Re: [SQL] LIMIT

    Mark Jewiss <mark@office.knowledge.com> — 1999-04-29T09:24:46Z

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

  5. Re: [SQL] LIMIT

    Jose Soares <jose@sferacarta.com> — 1999-04-29T13:28:16Z

    
Dirk Lutzebaeck ha scritto:

> Besides, I have problems with SELECT LIMIT on unions in
> 6.5beta1. Anyone else?
>
> Dirk

LIMIT doesn't work with UNION, I think this is a known bug.

José

  6. Re: [SQL] LIMIT

    Jose Soares <jose@sferacarta.com> — 1999-04-29T13:55:34Z

    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é

  7. Re: [SQL] LIMIT

    Jose Soares <jose@sferacarta.com> — 1999-04-29T14:02:15Z

    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  know nothing about SET ROWCOUNT, it doesn't work for me.
I see v6.5 accepts still SET QUERY_LIMIT TO #
but it doesn't work too.
______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'

  8. Re: [SQL] LIMIT

    Mark Jewiss <mark@office.knowledge.com> — 1999-04-29T14:57:38Z

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

  9. Re: [SQL] LIMIT

    Jose Soares <jose@sferacarta.com> — 1999-04-29T15:45:10Z

    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'