Simple mail() function for postgresql

Started by Trurl McByteover 25 years ago2 messagesgeneral
Jump to latest
#1Trurl McByte
trurl@anything3d.com

Hi.

Simple mail() function for postgresql,
very usefull in triggers (autologging via email, autoinvoice, email orders,
PBeM games and more
other).

ftp://ftp.trurl.anything3d.com/pub/Linux/our/mail.tar.gz
or
http://ftp.trurl.anything3d.com/Linux/our/mail.tar.gz

using: mail(to::varchar, subject::varchar, message::varchar, headers::varchar)
returns: 'true'::bool if all right, else is 'false'::bool

sample: select mail('root@localhost', 'Test', 'Ooops!!!', '');

PS. Don't use NULL in fields.
PPS. For UNIX-like system only now.

--
Trurl McByte, Capt. of StasisCruiser "Prince"
|InterNIC: AR3200 RIPE: AR1627-RIPE|
|--98 C3 78 8E 90 E3 01 35 87 1F 3F EF FD 6D 84 B3--|

#2Trurl McByte
trurl@anything3d.com
In reply to: Trurl McByte (#1)
Re: Simple mail() function for postgresql

On Mon, 18 Dec 2000 (Yesterday), Trurl McByte wrote:

TM> Hi.
TM>
TM> Simple mail() function for postgresql,
TM> very usefull in triggers (autologging via email, autoinvoice, email orders,
TM> PBeM games and more
TM> other).
TM>
TM> ftp://ftp.trurl.anything3d.com/pub/Linux/our/mail.tar.gz
TM> or
TM> http://ftp.trurl.anything3d.com/Linux/our/mail.tar.gz
TM>
TM> using: mail(to::varchar, subject::varchar, message::varchar, headers::varchar)
TM> returns: 'true'::bool if all right, else is 'false'::bool
TM>
TM> sample: select mail('root@localhost', 'Test', 'Ooops!!!', '');
TM>
TM>
TM> PS. Don't use NULL in fields.

NULL value error in fields fixed, empty & NULL values processing normally
now.

Package have a new name: pgsendmail
and location now
ftp://ftp.trurl.anything3d.com/pub/Linux/our/pgsendmail.tar.gz
or
http://ftp.trurl.anything3d.com/Linux/our/pgsendmail.tar.gz
(old location correct too)

TM> PPS. For UNIX-like system only now.
TM>
TM>
TM>

--
Trurl McByte, Capt. of StasisCruiser "Prince"
|InterNIC: AR3200 RIPE: AR1627-RIPE|
|--98 C3 78 8E 90 E3 01 35 87 1F 3F EF FD 6D 84 B3--|