Convert simple oracle procedure to postgres

We want to be able to send SMS messages from a stored procedure in postgres. The procedure must of course use the correct syntax of our suppliers gateway: The following url explains how to use our suppliers syntax from an oracle procedure:[ [login to view URL]][1] This code snippet show how URL requests can be used in (untrusted) postgres procedures: ---------------------------------- CREATE OR REPLACE FUNCTION reindex_by_uid (text) RETURNS text as ' $uid = shift; # Auth required to run PythonScript w/right role # or, dont pass auth stuff and make PyScript proxied to role $AUTH = "--http-user=joel --http-passwd=foo"; # Set to your server and portal name $SERVER = "http://localhost:8080/arch"; # wget options # -q is quiet (no status output) # -O - is to send results to standard output # -T 5 is to timeout after 5 seconds $WGET = "/usr/bin/wget -q -O - -T 5"; $cmd = "$WGET $AUTH $SERVER/reindex_by_uid?uid=$uid"; # output it to psql log so the user has some idea whats going on elog NOTICE, $cmd; return `$cmd`; ' LANGUAGE plperlu; ---------------------------------- For more info, see <[login to view URL]> Best regards, Magnus ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Postgres