pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedmaximum rows to retrive
5+ messages / 3 participants
[nested] [flat]
* maximum rows to retrive
@ 2011-02-01 17:44 Antonio Biondo <antonio.84@email.it>
0 siblings, 1 reply; 5+ messages in thread
From: Antonio Biondo @ 2011-02-01 17:44 UTC (permalink / raw)
To: pgsql-admin
Hi, i not found in query tool of PgAdmin III the option to set "maximum
rows to retrive". Is there no this option?
--
Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it http://www.email.it/f
Sponsor:
Apri Conto Corrente Arancio entro il 28 febbraio 2011 e ricevi 100 euro da spendere su Media World compra online. Aprilo adesso!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=11252&d=1-2
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: maximum rows to retrive
@ 2011-02-03 23:44 Guillaume Lelarge <guillaume@lelarge.info>
parent: Antonio Biondo <antonio.84@email.it>
0 siblings, 2 replies; 5+ messages in thread
From: Guillaume Lelarge @ 2011-02-03 23:44 UTC (permalink / raw)
To: Antonio Biondo <antonio.84@email.it>; +Cc: pgsql-admin
Le 01/02/2011 18:44, Antonio Biondo a écrit :
> Hi, i not found in query tool of PgAdmin III the option to set "maximum
> rows to retrive". Is there no this option?
>
This option only exists in the data grid. If you need this in the query
editor, add a LIMIT clause on your queries.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: maximum rows to retrive
@ 2011-02-04 11:13 Lukasz Brodziak <lukasz.brodziak@gmail.com>
parent: Guillaume Lelarge <guillaume@lelarge.info>
1 sibling, 0 replies; 5+ messages in thread
From: Lukasz Brodziak @ 2011-02-04 11:13 UTC (permalink / raw)
To: Guillaume Lelarge <guillaume@lelarge.info>; +Cc: Antonio Biondo <antonio.84@email.it>; pgsql-admin
Hi,
Antonio You have to remember to put ORDER BY clause because LIMIT
returns random rows if You would like to return let's say 100 rows
starting from row #250 the query would be sth like this:
SELECT emp_id, name, surname, dept FROM empleyees LIMIT 100 OFFSET 250
ORDER BY emp_id
2011/2/4 Guillaume Lelarge <guillaume@lelarge.info>:
> Le 01/02/2011 18:44, Antonio Biondo a écrit :
>> Hi, i not found in query tool of PgAdmin III the option to set "maximum
>> rows to retrive". Is there no this option?
>>
>
> This option only exists in the data grid. If you need this in the query
> editor, add a LIMIT clause on your queries.
>
>
> --
> Guillaume
> http://www.postgresql.fr
> http://dalibo.com
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Łukasz Brodziak
"What if everyting around You isn't quite as it seems,
What if all the world You think You know is an inelaborate dream
When You look at Your reflection is that all you want it to be
What if You could look right through the cracks
Would You find Yourself...... Find Yourself afraid to see"
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: maximum rows to retrive
@ 2011-02-08 09:27 Antonio Biondo <antonio.84@email.it>
parent: Guillaume Lelarge <guillaume@lelarge.info>
1 sibling, 1 reply; 5+ messages in thread
From: Antonio Biondo @ 2011-02-08 09:27 UTC (permalink / raw)
To: Guillaume Lelarge <guillaume@lelarge.info>; +Cc: pgsql-admin
Hi, tnx for the answer. Do you think that will be add a option in the
menù for query editor too? Mysql workbench has it, i would appreciate it
in Pgadmin III...
Best regards,
Antonio
Il 04/02/2011 00:44, Guillaume Lelarge ha scritto:
> Le 01/02/2011 18:44, Antonio Biondo a écrit :
>> Hi, i not found in query tool of PgAdmin III the option to set "maximum
>> rows to retrive". Is there no this option?
>>
> This option only exists in the data grid. If you need this in the query
> editor, add a LIMIT clause on your queries.
>
>
--
Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it http://www.email.it/f
Sponsor:
Apri Conto Corrente Arancio entro il 28 febbraio 2011 e ricevi 100 euro da spendere su Media World compra online. Aprilo adesso!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=11252&d=8-2
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: maximum rows to retrive
@ 2011-02-08 23:01 Guillaume Lelarge <guillaume@lelarge.info>
parent: Antonio Biondo <antonio.84@email.it>
0 siblings, 0 replies; 5+ messages in thread
From: Guillaume Lelarge @ 2011-02-08 23:01 UTC (permalink / raw)
To: Antonio Biondo <antonio.84@email.it>; +Cc: pgsql-admin
Le 08/02/2011 10:27, Antonio Biondo a écrit :
> Hi, tnx for the answer. Do you think that will be add a option in the
> menù for query editor too? Mysql workbench has it, i would appreciate it
> in Pgadmin III...
>
No. The user writes his query, I'm not sure he would like we mess with
it adding different kind of things (you're talking about LIMIT, but then
someone else will want OFFSET, ORDER BY, ...).
But you can still ask this on pgadmin-support ML. Not sure a hacker
there will work on this.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2011-02-08 23:01 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-02-01 17:44 maximum rows to retrive Antonio Biondo <antonio.84@email.it>
2011-02-03 23:44 ` Guillaume Lelarge <guillaume@lelarge.info>
2011-02-04 11:13 ` Lukasz Brodziak <lukasz.brodziak@gmail.com>
2011-02-08 09:27 ` Antonio Biondo <antonio.84@email.it>
2011-02-08 23:01 ` Guillaume Lelarge <guillaume@lelarge.info>
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