Simple mail() function for postgresql

From: Trurl McByte <trurl(at)anything3d(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Simple mail() function for postgresql
Date: 2000-12-18 11:07:51
Message-ID: Pine.LNX.4.20.0012181307190.30783-100000@trurl.anything3d.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)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--|

Browse pgsql-general by date

  From Date Subject
Next Message Rolf Johansson 2000-12-18 13:16:52 More on character encoding in SELECTs
Previous Message Trurl McByte 2000-12-18 11:02:11 Simple mail() function for postgresql