limit in PostgreSQL

[Jason FU]

In Oracle, we have rowid for limiting the number of selected rows/records.
In PostgreSQL, we have limit and offset. But how do we use limit in the
MapServer. For Oracle spatial, we simply add rowid in the FILTER statement.
What do we do in PostGIS connection?

Thanks.

Jason