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@xxxxxxxxxxxx>: > 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@xxxxxxxxxxxxxx) > 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" -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
