Re: [GENERAL] Row Nums - Mailing list pgsql-general

From Jose' Soares
Subject Re: [GENERAL] Row Nums
Date
Msg-id 361C6DEF.B2E09145@sferacarta.com
Whole thread Raw
In response to Row Nums  (Anand Surelia <anand@bytekinc.com>)
List pgsql-general
Anand Surelia wrote:
>
> Hi,
> I want to display serial numbers of rows selected by a query. I can do
> this in Oracle by selecting a special attribute called 'rownum' (or
> 'rowno'). Can I do this in Postgres too? If not then is there any
> alternative in Postgres?
>
SELECT oid, * FROM tablename;

Jose'

pgsql-general by date:

Previous
From: Jun Kuwamura
Date:
Subject: [pgsql-jp 5574] Re: Is array_iterator.c work? (fwd)
Next
From: Memphisto
Date:
Subject: No clue for embedded SQL