pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
LIMIT
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