Re: limiting rows in an query

  I think there isn't a portable way.
  In Oracle each row of a query have a sequential number, called
"rowid", I think.
  So, in oracle you do somethink like
  ...AND ROWID >= 0 AND ROWID <20
  Disgusting, isn't it? :-)

On Mon, 2002-09-30 at 13:55, David Wall wrote:
> Does anybody know how to do this in a "portable" way?  For example, I don't
> think Oracle has the LIMIT clause capability...
> 
> David
> 
-- 

Felipe Schnack
Analista de Sistemas
felipes@xxxxxxxxxxxxxxxx
Cel.: (51)91287530
Linux Counter #281893

Faculdade Ritter dos Reis
www.ritterdosreis.br
felipes@xxxxxxxxxxxxxxxx
Fone/Fax.: (51)32303328


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org