Display a number value in Words

[alamb]

I would be happy to incorporate this code into our github extensions repository (https://github.com/vertica/Vertica-Extension-Packages)

For legal reasons, I can not include it unless you sign a contributor license agreement, which is straightforward and easy to do:

Quoting from:
https://github.com/vertica/Vertica-Exte ... README.txt

IMPORTANT: If you wish to contribute anything to this repository, in
order for us to accept your pull request you MUST sign and send a copy
of the appropriate Contributor License Agreement to Vertica
(contribs@vertica.com):

license/PersonalCLA.pdf: If you are contributing for yourself
license/CorporateCLA.pdf: If you are contributing on behalf of your company

File links:
https://github.com/vertica/Vertica-Exte ... nalCLA.pdf
https://github.com/vertica/Vertica-Exte ... ateCLA.pdf

[Julie]

sKwa,

Thanks! That's so cool!

Code: Select all

dbadmin=> select spell_number(8) || ' plus ' || spell_number(8) || ' equals ' || spell_number(16) cool
              cool
---------------------------------
 eight plus eight equals sixteen
(1 row)

[DGh]

Hi ,
Is there any way to return the output of a python function as an external procedure in Vertica.
I need to create a UUID generator function - and would like to have something that I can embedd in a query: select uuid_gen(), other col from table

Looks like with python I can only return an exit status. (same with uuidgen in shell) there anything else I can do?

thanks,
Dgh

[JimKnicely]

DGh,

You need to ask your question in the "Connecting to Vertica/Python" forum here:

http://www.vertica-forums.com/viewforum.php?f=35

Otherwise no one will read it because it has nothing to do with the original subject in the thread to which you posted your question

[id10t]

Hi!

[DELETED]

[nnani]

Thanks for the UDF skwa.

[DGh]

>> Is there any way to return the output of a python function as an external procedure in Vertica.
No.

Thanks Skwa, I figured that out yesterday (that I could only return exist statuses for scripts).
Wrote a c++ prog using Boost library and followed your instructions for compiling (new to c++ as well ) and it works like charm!

Thank you all for the help. This forum is a great platform for beginners like me

DGh