serial in output - Mailing list pgsql-sql

From alessandra de gregorio
Subject serial in output
Date
Msg-id 20051028111824.C8C7DDA53F@svr1.postgresql.org
Whole thread Raw
Responses Re: serial in output
List 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





pgsql-sql by date:

Previous
From: Thomas Good
Date:
Subject: JOIN condition confusion
Next
From: Michael Glaesemann
Date:
Subject: Re: Design question: Scalability and tens of thousands of tables?