pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedLIMIT
9+ messages / 5 participants
[nested] [flat]
* LIMIT
@ 1999-04-29 05:22 Mr. Poet <poet@linuxports.com>
0 siblings, 1 reply; 9+ messages in thread
From: Mr. Poet @ 1999-04-29 05:22 UTC (permalink / raw)
To: pgsql-sql
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--
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [SQL] LIMIT
@ 1999-04-29 05:47 Chris Bitmead <chris.bitmead@bigfoot.com>
parent: Mr. Poet <poet@linuxports.com>
0 siblings, 2 replies; 9+ messages in thread
From: Chris Bitmead @ 1999-04-29 05:47 UTC (permalink / raw)
To: pgsql-sql
"Mr. Poet" wrote:
>
> Could someone give me an example of a select * with LIMIT
> used by 6.5?
SELECT * FROM foobar LIMIT 100
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [SQL] LIMIT
@ 1999-04-29 08:06 Dirk Lutzebaeck <lutzeb@aeccom.com>
parent: Chris Bitmead <chris.bitmead@bigfoot.com>
1 sibling, 1 reply; 9+ messages in thread
From: Dirk Lutzebaeck @ 1999-04-29 08:06 UTC (permalink / raw)
To: pgsql-sql
Besides, I have problems with SELECT LIMIT on unions in
6.5beta1. Anyone else?
Dirk
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [SQL] LIMIT
@ 1999-04-29 09:24 Mark Jewiss <mark@office.knowledge.com>
parent: Chris Bitmead <chris.bitmead@bigfoot.com>
1 sibling, 2 replies; 9+ messages in thread
From: Mark Jewiss @ 1999-04-29 09:24 UTC (permalink / raw)
To: Chris Bitmead <chris.bitmead@bigfoot.com>; +Cc: pgsql-sql
> > 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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [SQL] LIMIT
@ 1999-04-29 13:28 José Soares <jose@sferacarta.com>
parent: Dirk Lutzebaeck <lutzeb@aeccom.com>
0 siblings, 0 replies; 9+ messages in thread
From: José Soares @ 1999-04-29 13:28 UTC (permalink / raw)
To: Dirk Lutzebaeck <lutzeb@aeccom.com>; +Cc: pgsql-sql
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é
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [SQL] LIMIT
@ 1999-04-29 13:55 José Soares <jose@sferacarta.com>
parent: Mark Jewiss <mark@office.knowledge.com>
1 sibling, 1 reply; 9+ messages in thread
From: José Soares @ 1999-04-29 13:55 UTC (permalink / raw)
To: Mark Jewiss <mark@office.knowledge.com>; +Cc: Chris Bitmead <chris.bitmead@bigfoot.com>; hackers <pgsql-hackers@postgresql.org>
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é
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [SQL] LIMIT
@ 1999-04-29 14:02 José Soares <jose@sferacarta.com>
parent: Mark Jewiss <mark@office.knowledge.com>
1 sibling, 0 replies; 9+ messages in thread
From: José Soares @ 1999-04-29 14:02 UTC (permalink / raw)
To: Mark Jewiss <mark@office.knowledge.com>; +Cc: Chris Bitmead <chris.bitmead@bigfoot.com>; hackers <pgsql-hackers@postgresql.org>
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'
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [SQL] LIMIT
@ 1999-04-29 14:57 Mark Jewiss <mark@office.knowledge.com>
parent: José Soares <jose@sferacarta.com>
0 siblings, 1 reply; 9+ messages in thread
From: Mark Jewiss @ 1999-04-29 14:57 UTC (permalink / raw)
To: José Soares <jose@sferacarta.com>; +Cc: Chris Bitmead <chris.bitmead@bigfoot.com>; hackers <pgsql-hackers@postgresql.org>
> 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.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [SQL] LIMIT
@ 1999-04-29 15:45 José Soares <jose@sferacarta.com>
parent: Mark Jewiss <mark@office.knowledge.com>
0 siblings, 0 replies; 9+ messages in thread
From: José Soares @ 1999-04-29 15:45 UTC (permalink / raw)
To: Mark Jewiss <mark@office.knowledge.com>; +Cc: Chris Bitmead <chris.bitmead@bigfoot.com>; hackers <pgsql-hackers@postgresql.org>
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'
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~1999-04-29 15:45 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-04-29 05:22 LIMIT Mr. Poet <poet@linuxports.com>
1999-04-29 05:47 ` Chris Bitmead <chris.bitmead@bigfoot.com>
1999-04-29 08:06 ` Dirk Lutzebaeck <lutzeb@aeccom.com>
1999-04-29 13:28 ` José Soares <jose@sferacarta.com>
1999-04-29 09:24 ` Mark Jewiss <mark@office.knowledge.com>
1999-04-29 13:55 ` José Soares <jose@sferacarta.com>
1999-04-29 14:57 ` Mark Jewiss <mark@office.knowledge.com>
1999-04-29 15:45 ` José Soares <jose@sferacarta.com>
1999-04-29 14:02 ` José Soares <jose@sferacarta.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox