Обсуждение: each line counter

Hi
I would like to add counter in front of each row with select
command.

Does anyone have some idea?
Thnx

Zvonimir Radek wrote:
> Hi
> I would like to add counter in front of each row with select
> command.

You can sort-of do this by creating a sequence and then dropping it
after the query, but basically this is the sort of thing you do in the
client application usually.


--
   Richard Huxton
   Archonet Ltd

On Fri, 2006-03-17 at 09:30, Richard Huxton wrote:
> Zvonimir Radek wrote:
> > Hi
> > I would like to add counter in front of each row with select
> > command.
>
> You can sort-of do this by creating a sequence and then dropping it
> after the query, but basically this is the sort of thing you do in the
> client application usually.

Note that you can create a temporary sequence for this.  That way, if
two sessions need to do this at the same time they won't bump into each
other.  Plus, the sequence gets automatically dropped at the end of your
session.