Re: [GENERAL] Row Nums

From: "Jose' Soares" <jose(at)sferacarta(dot)com>
To: Anand Surelia <anand(at)bytekinc(dot)com>
Cc: "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] Row Nums
Date: 1998-10-08 07:46:55
Message-ID: 361C6DEF.B2E09145@sferacarta.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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'

In response to

  • Row Nums at 1998-10-07 17:58:34 from Anand Surelia

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jun Kuwamura 1998-10-08 08:51:38 [pgsql-jp 5574] Re: Is array_iterator.c work? (fwd)
Previous Message Bruce Momjian 1998-10-07 21:33:07 Re: [HACKERS] RE: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF)