Re: maximum rows to retrive

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(at)lelarge(dot)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(at)postgresql(dot)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"