Re: (none)

On Tue, Dec 30, 2003 at 19:32:03 +0530,
  Sh A Guru Prasad <guru@ap.nic.in> wrote:
>
> Hi, How to convert number format (with decimal) into
> integer only ex:to conver 100.00 to 100.

Depending on what kind of rounding you want, you can just cast to
an integer. You could also use ceil, floor or round.

> One more
> Do we have any code to convert number to words
> ex: 1234 to one thousand two hundredn and thirty four.

I don't think there is currently a supplied function to do this. You
will need to write your own.

> (I want to use for indian currency only, i will use crores
> instead of billions)
>
> Thank you
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly