serial in output

From: "alessandra de gregorio" <adegregorio(at)fgscapital(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: serial in output
Date: 2005-10-28 11:18:21
Message-ID: 20051028111824.C8C7DDA53F@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

What function should I use to get a serial number, together with my results,
from a query?

Ex. Of output I want:

1 ooo pp ij
2 hou joo iu
3 bhi ft yh

Basically, I would like to have one column with integers, from 1 onwards, no
matter how many tables I join in, or the data that I get back.

Thanks

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2005-10-28 13:34:30 Re: why vacuum
Previous Message Mario Splivalo 2005-10-28 11:09:43 Re: why vacuum