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

Wed, 28 Apr 1999 22:22:58 -0700
"Mr. Poet" <poet@linuxports.com>
LIMIT
"Mr. Poet" wrote:
> 
> Could someone give me an example of a select * with LIMIT 
> used by 6.5?

SELECT * FROM foobar LIMIT 100

Thu, 29 Apr 1999 05:47:35 +0000
Chris Bitmead <chris.bitmead@bigfoot.com>
Re: [SQL] LIMIT

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

Dirk

Thu, 29 Apr 1999 10:06:18 +0200 (CEST)
Dirk Lutzebaeck <lutzeb@aeccom.com>
Re: [SQL] LIMIT
> > 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


Thu, 29 Apr 1999 10:24:46 +0100 (BST)
Mark Jewiss <mark@office.knowledge.com>
Re: [SQL] LIMIT


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ï¿½


Thu, 29 Apr 1999 15:28:16 +0200
=?iso-8859-1?Q?Jos=E9?= Soares <jose@sferacarta.com>
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ï¿½


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é
Thu, 29 Apr 1999 15:55:34 +0200
=?iso-8859-1?Q?Jos=E9?= Soares <jose@sferacarta.com>
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  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'



Thu, 29 Apr 1999 16:02:15 +0200
=?iso-8859-1?Q?Jos=E9?= Soares <jose@sferacarta.com>
Re: [SQL] LIMIT
> 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.


Thu, 29 Apr 1999 15:57:38 +0100 (BST)
Mark Jewiss <mark@office.knowledge.com>
Re: [SQL] LIMIT
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'



Thu, 29 Apr 1999 17:45:10 +0200
=?iso-8859-1?Q?Jos=E9?= Soares <jose@sferacarta.com>
Re: [SQL] LIMIT