From: ashok@kalculate.com <ashok@kalculate.com>
To: pgsql-sql@postgresql.org
Subject: Serial number of a record
Date: Tue, 15 May 2007 07:40:25 -0400
Message-ID: <380-220075215114025163@M2W015.mail2web.com> (raw)
Hi List,
I have one table something like this
Name Age
=================
tom 20
ram 25
shyam 30
balram 15
hari 10
Now i want serial number of a record.
Suppose if i will fire a query "select Name from tablename where age=30".
it will give output "shyam" but i also want record no. other then oid, in
this case it is 3.
is it possible?
if yes then how?
plz. help me.
Thanks
Ashok
--------------------------------------------------------------------
mail2web.com - Microsoft® Exchange solutions from a leading provider -
http://link.mail2web.com/Business/Exchange
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ashok@kalculate.com
Subject: Re: Serial number of a record
In-Reply-To: <380-220075215114025163@M2W015.mail2web.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox