Re: limiting rows in an query

From: Felipe Schnack <felipes(at)ritterdosreis(dot)br>
To: David Wall <dwall(at)Yozons(dot)com>
Cc: Michael Paesold <mpaesold(at)gmx(dot)at>, pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: limiting rows in an query
Date: 2002-09-30 16:56:34
Message-ID: 1033404994.1813.15.camel@desenv1.ritterdosreis.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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(at)ritterdosreis(dot)br
Cel.: (51)91287530
Linux Counter #281893

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message David Wall 2002-09-30 17:19:04 Fw: limiting rows in an query
Previous Message David Wall 2002-09-30 16:55:00 Re: limiting rows in an query