setting select limit? - Mailing list pgsql-sql

If a select is going to match 1000 records, but I only want to
select the first 25, I thought I could:

select * from table limit 25;

But I guess I can't. How do I limit the query? I've search
around with no results. Thanks.