convert 1 to 1st, 2 to 2nd, 3 to 3rd

[gezeala]

I need help..

Is there a function in PHP or Postgresql that converts cardinal numbers (1,2,3, etc) to ordinal numbers in the form 1st, 2nd, 3rd and so on...?

thanks a lot in advance...

[Anon]

Well, it's a very locale-specific problem. There's no such function in PHP and I doubt there's such a function in PostgreSQL.

But there's no real need for one:

$number=241;
switch(substr($number,-1))
{ case 1: $number.="st"; break;
case 2: $number.="nd"; break;
case 3: $number.="rd"; break;
default: $number.="th"; break;
}
echo $number;