PHP Postgres SQL row number

[pesce]

Hi,

I am using php and postgres sql. How do I get the row number from a select?
In the database I have a list of people with their weight and they are ordered from the heaviest to the less heavy. The names are all different.
I want to search for a name and get his position on the ladder.
Example:

luke 88lb
jack 70lb
john 56lb
maria 45lb

I want to be able to tell that john for example is the third heaviest.

Thanks

[Sxooter]

There is no intrinsic row numbering. Luckily, PostgreSQL has everything you need to make one on your own.

create temporary sequence myrow;
select *,nextval('myrow') from ...  <-- your query, with the nextval('seqname') here...