serial number in output

From: "alessandra de gregorio" <adegregorio(at)fgscapital(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: serial number in output
Date: 2005-10-28 13:42:08
Message-ID: 20051028134212.72DBCDB212@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-10-28 13:56:46 Re: Function written in C, hangs on one machine and not another...
Previous Message CG 2005-10-28 13:38:29 Function written in C, hangs on one machine and not another...