Converting number to words

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Robert Fitzpatrick

    #1

    Converting number to words

    I searched through the net quickly and the list archives, but could not
    find anything doing this. Is it possible? There is a Perl module for
    doing this, but I guess cannot use modules for security reasons.

    --
    Robert


    ---------------------------(end of broadcast)---------------------------
    TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddres sHere" to majordomo@postg resql.org)

  • Alvaro Herrera

    #2
    Re: Converting number to words

    On Fri, Nov 05, 2004 at 05:18:01PM -0500, Robert Fitzpatrick wrote:[color=blue]
    > I searched through the net quickly and the list archives, but could not
    > find anything doing this. Is it possible? There is a Perl module for
    > doing this, but I guess cannot use modules for security reasons.[/color]

    But you can use plperlu to define a function to do that.

    --
    Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
    "La rebeldía es la virtud original del hombre" (Arthur Schopenhauer)


    ---------------------------(end of broadcast)---------------------------
    TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddres sHere" to majordomo@postg resql.org)

    Comment

    • Bruce Momjian

      #3
      Re: Converting number to words

      Alvaro Herrera wrote:[color=blue]
      > On Fri, Nov 05, 2004 at 05:18:01PM -0500, Robert Fitzpatrick wrote:[color=green]
      > > I searched through the net quickly and the list archives, but could not
      > > find anything doing this. Is it possible? There is a Perl module for
      > > doing this, but I guess cannot use modules for security reasons.[/color]
      >
      > But you can use plperlu to define a function to do that.[/color]

      cash_words() will convert an int4.

      --
      Bruce Momjian | http://candle.pha.pa.us
      pgman@candle.ph a.pa.us | (610) 359-1001
      + If your life is a hard drive, | 13 Roberts Road
      + Christ can be your backup. | Newtown Square, Pennsylvania 19073

      ---------------------------(end of broadcast)---------------------------
      TIP 7: don't forget to increase your free space map settings

      Comment

      Working...