Re: each line counter

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.